LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Abi
 
Posts: n/a
Default 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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
show macro security setting in a cell Mark Excel Worksheet Functions 3 March 21st 05 07:53 AM
Setting macro security level to "low" permanently? Arobind Excel Discussion (Misc queries) 1 December 22nd 04 01:41 AM
Print Macro NICK Excel Discussion (Misc queries) 1 December 20th 04 03:20 AM
Macro for changing print settings Bill Excel Discussion (Misc queries) 3 December 3rd 04 10:49 PM
macro to not print blank value rows in invoice Dave Excel Worksheet Functions 1 November 3rd 04 07:21 PM


All times are GMT +1. The time now is 06:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"