Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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.
|
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() "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 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Ah, working now. I think it was a Trust Center setting. All good now. Not perfect, but acceptable to my needs. Thanks so much...
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
prevent certain cells from printing | Excel Discussion (Misc queries) | |||
Prevent printing a sheet | Excel Discussion (Misc queries) | |||
Prevent Printing | Excel Discussion (Misc queries) | |||
Prevent Printing | Excel Programming | |||
Prevent printing of some sheets and not others in a single doc? | Excel Programming |