Print dialog

  • Thread starter Thread starter MN
  • Start date Start date
M

MN

Hi, somebody knows as to show the picture of I engage in a dialog of the
printer, the same one that appears when one does click in menu of file.

Thank,
MN
 
MN said:
Hi, somebody knows as to show the picture of I engage in a dialog of the
printer, the same one that appears when one does click in menu of file.
Click to expand...

Hi MN,

I'm not sure I understand what you are asking for, but if you want to
use VBA to display the same dialog that is displayed when you select
File/Print from the Excel menu you can do it like this:

Application.Dialogs(xlDialogPrint).Show

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *
 
Back
Top