| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Printing Selected worksheets but exclude the sheet "Sheets" | Excel Discussion (Misc queries) | |||
| Printing selected columns | Excel Discussion (Misc queries) | |||
| Printing selected sheets. | Excel Worksheet Functions | |||
| Help printing selected rows | Excel Discussion (Misc queries) | |||
| Printing only a selected area | Excel Programming | |||
Linear Mode
