ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Setting up a macro to print? (https://www.excelbanter.com/excel-worksheet-functions/8981-setting-up-macro-print.html)

Abi

Setting up a macro to print?
 
If I have 20 pages in a workbook, some of which are just calculation pages
and some of which are pages for distribution, can I use a macro of some
sorts, or even better, create a form on another sheet that allows the user to
check off which sheets they would like to print?

And to throw more into the mix, can I have them print the page number at the
bottom of each page?

Example:
Sheet 1 - Data Entry Sheet
Sheet 2 - Output sheet 3 pages long
Sheet 3 - Output sheet 1 page long
Sheet 4 - Data Entry Sheet
Sheet 5 - Output sheet 2 pages long

I want a form (or some tool) that a user goes to and checks off:
- print sheet 3, (page 1)
- print sheet 5, (pages 2 and 3)
- print sheet 2, (pages 4, 5 and 6)

Am I way out of me league on this one?


All times are GMT +1. The time now is 05:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com