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" wrote in message
...

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