Printing automatically

[AmyTaylor]

Hi all, hope someone can help:

I have a spreadsheet containing 5 worksheets, all with a print-area set and are ready to print.

To help the "customer", I would ideally like a macro that opens each sheet and automatically prints it, then at the final sheet goes back to the first sheet and stops.

Can anyone give me any pointers?
Thanks
Amy xx

[Ron de Bruin]

Hi Amy

See this page for a one liner
http://www.rondebruin.nl/print.htm#Print


--
Regards Ron de Bruin
http://www.rondebruin.nl


"AmyTaylor" <AmyTaylor.1s056c_1121079912.002@excelforum-nospam.com> wrote in message
news:AmyTaylor.1s056c_1121079912.002@excelforum-nospam.com...
>
> Hi all, hope someone can help:
>
> I have a spreadsheet containing 5 worksheets, all with a print-area set
> and are ready to print.
>
> To help the "customer", I would ideally like a macro that opens each
> sheet and automatically prints it, then at the final sheet goes back to
> the first sheet and stops.
>
> Can anyone give me any pointers?
> Thanks
> Amy xx
>
>
> --
> AmyTaylor
> ------------------------------------------------------------------------
> AmyTaylor's Profile: http://www.excelforum.com/member.php...o&userid=20970
> View this thread: http://www.excelforum.com/showthread...hreadid=386076
>

[AmyTaylor]

Hi Ron, thanks for your help !

Amy xx