Need a pause in a print macro.

Giganews Newsgroups
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.

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

Replies