Printing Selected Worksheets
 

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.

Printing Selected Worksheets
 

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.

Printing Selected Worksheets
 

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.

Printing Selected Worksheets
 

Thanks for the feedback

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


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