|Subject:||Need a pause in a print macro.|
|Posted by:||Kevin (kevin.brenn…@worldnet.att.net)|
|Date:||Thu, 02 Oct 2003|
I created a macro that copies and pastes some data into a sheet and then it
prints. What I what to do is to get to the print menu and then I click on OK
to print if all the data looks ok. At the moment is just goes trough the
macro and it never pause for the print menu box.
this is the code at the moment.
' ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Thank you very much for your help!