Limit Printing on specific worksheets in Excel

[shifty21]

Here's my problem:

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

http://groups.google.ca/group/micro...f0fe28be1e4/2f969e4036463e2c#2f969e4036463e2c

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?

 

[Sandy Mann]

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

You could write a BeforePrint Macro but then you would never be able to
print anything else. You could add an option in the BeforePrint Macro to
ask if you want to set the Print Area and exit the Sub() if not but then any
user could select that option and thus print Month B's before it is ready.

A third option would be to have the BeforePrint Macro to check an entry in
the spreadsheet and if it has the right data, (which only you know), exit
the Sub()

What exactly is it you want to do?
--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[Dave Peterson]

Disable printing with the workbook_beforeprint event.

Provide a macro that only prints what you want to print.

In that macro, you'll have to disable events before you try to print, though.