Need a pause in a print macro.

  • Thread starter Thread starter Kevin
  • Start date Start date
K

Kevin

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.

Sub PrintTimeSheet_1()
etc,etc,etc
Range("B5").Select
' ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
End Sub

Thank you very much for your help!
Kevin Brenner
 
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
to this
ActiveWindow.SelectedSheets.PrintPreview

--
Paul B
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 **
 
One possibility:

rather than use printout use

application.Dialogs(xlDialogPrint).Show
 
Back
Top