|Subject:||Re: Need a pause in a print macro.|
|Posted by:||Paul B (newsp…@surfbest.net)|
|Date:||Wed, 1 Oct 2003|
Kevin, one way is to bring up the print preview and then click print from
there if everything looks OK just change
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
"Kevin" <kevin.brenn…@worldnet.att.net> wrote in message
> I created a macro that copies and pastes some data into a sheet and then
> prints. What I what to do is to get to the print menu and then I click on
> 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.
> Sub PrintTimeSheet_1()
> ' ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
> End Sub
> Thank you very much for your help!
> Kevin Brenner
Need a pause in a print macro. posted by Kevin on Thu, 02 Oct 2003