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.

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.