View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] shifty21@gmail.com is offline
external usenet poster
 
Posts: 1
Default Limit Printing on specific worksheets in Excel

Here's my problem:

I was able to find some code to disable printing for the entire
workbook:

http://groups.google.ca/group/micros...969e4036463e2c

But...I would like to limit printing on some pages and not others.
Here's my situation. I have month A's schedule completed and ready for
distribution. I don't have month B's schedule ready yet. I don't want
any user to be able to print month B's schedule but at the same time I
don't want to have to hide and unhide it all the time. Is there a
happy medium?