Print dialog

[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

 

[Rob Bovey]

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.

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 *

 

[MN]

Thanks for the help.