Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I initiate the windows printer select object in Excel macro
I have a form that was created in Excel that as a control number on it. I
have placed a button on the worksheet which asks how many copies. It increments the control number by one, prints and then repeats until all have been printed. The printout method simply uses the default or selected printed. I need to know how to bring up the standad windows printer selection object so I can select the printer (the same object that comes up when you press ctrl-P. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I initiate the windows printer select object in Excel macro
Mick,
Use application.Dialogs(xlDialogPrint).Show ,,,myNumCopies and substitute myNumCopies with your variable -- HTH ------- Bob Phillips "Mick B" <Mick wrote in message ... I have a form that was created in Excel that as a control number on it. I have placed a button on the worksheet which asks how many copies. It increments the control number by one, prints and then repeats until all have been printed. The printout method simply uses the default or selected printed. I need to know how to bring up the standad windows printer selection object so I can select the printer (the same object that comes up when you press ctrl-P. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating resizing macro - select chart as object? | Charts and Charting in Excel | |||
select printer macro | Excel Worksheet Functions | |||
No printer select in excel | Excel Discussion (Misc queries) | |||
Initiate perl script in linux from a Windows VBA program | Excel Programming | |||
Cannot select object to assign/edit macro | Excel Programming |