Many thanks for helping me with my page problem!
Plenty of useful info on your link too.
Thanks again.
"Ron de Bruin" wrote:
Hi
50 pages?
Do you mean sheets
Use this
ActiveWindow.SelectedSheets.PrintOut
See also
http://www.rondebruin.nl/print.htm#Print
--
Regards Ron de Bruin
http://www.rondebruin.nl
"B Baggins" wrote in message ...
I have a workbook with over 50 pages. I know how to set up a single button
to print All the sheets but my problem is that not all the pages require
printing. I want the user to select which pages they want to print via check
boxes and then press a print button.
Any ideas how I do this? Many thanks.