Print dialog
 

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

Print dialog
 

The fastest way I've seen to engage the print dialog is using the
SendKeys method:

ActiveWorkbook.Application.SendKeys ("^p")

Let me know if you have problems.

Mark

---
Mark Bigelow
mjbigelow at hotmail dot com
http://hm.imperialoiltx.com

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Print dialog
 

"MN" wrote in message
...
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 *

Print dialog
 

Thanks for the help.


"MN" escribió en el mensaje
...
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