Prevent printing of certain sheets
"Paul Martin" wrote in message
Peter, I gave it a go, both using Now and Now + TimeValue("0:0:15") and
both times I got an error indicating the macro couldn't be found.
The point about calling with OnTIme is the macro won't fire until other
things have completed, such as OK'ing or cancelling the print dialog. You
could add a delay if you want but shouldn't be necessary.
About the 'couldn't be found', did you put the macro in a normal module and
include the pair of apostrophes inside the string quotes, they're needed
when including arguments.
If still can't get it to work try separate macros to show/hide, remove the
true/false argument and the apostrophes. Another thing you could try is
qualifying the macro name with its module name.
Peter T
|