Re: Need a pause in a print macro.

Giganews Newsgroups
Subject: Re: Need a pause in a print macro.
Posted by:  Tom Ogilvy (twogil…@msn.com)
Date: Wed, 1 Oct 2003

One possibility:

rather than use printout use

application.Dialogs(xlDialogPrint).Show

--
Regards,
Tom Ogilvy

Kevin <kevin.brenn…@worldnet.att.net> wrote in message
news:9XLeb.166476$3o3.120142…@bgtnsc05-news.ops.worldnet.att.net...
> 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

In response to

Need a pause in a print macro. posted by Kevin on Thu, 02 Oct 2003