Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
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 * |
#4
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print Dialog Box | Excel Worksheet Functions | |||
Print Dialog box | Excel Discussion (Misc queries) | |||
Opening Excel - getting print dialog box | Excel Discussion (Misc queries) | |||
Print dialog box selection macro | Excel Discussion (Misc queries) | |||
get information from Print dialog | Excel Programming |