Thread: Print dialog
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming
Rob Bovey Rob Bovey is offline
external usenet poster
 
Posts: 811
Default 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 *