Printing without using dialogue box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nishant Patel - 20 Jul 2004 10:35 GMT

Hi I hope someone can help, I'm trying to print a range of
pages without using the print dialogue box if that makes
any sense. For instance I want to be able to say print
page 1 from the worksheet without having to go through and
use the print dialogue box. Hope you can help.

Reply to this Message

Paul B - 20 Jul 2004 11:32 GMT

Nishant, you could use a macro to do it, something like this

Sub Print_Page_One()
ActiveWindow.SelectedSheets.PrintOut From:=1, To:=1, Copies:=1, Collate
_
:=True
End Sub

Signature

Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **

> Hi I hope someone can help, I'm trying to print a range of
> pages without using the print dialogue box if that makes
> any sense. For instance I want to be able to say print
> page 1 from the worksheet without having to go through and
> use the print dialogue box. Hope you can help.

Reply to this Message

- 22 Jul 2004 09:30 GMT

Thanks for the help

>-----Original Message-----
>Nishant, you could use a macro to do it, something like this
[quoted text clipped - 12 lines]
>
>.

Reply to this Message