Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 133
Default Prevent printing of certain sheets

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 162
Default 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


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 133
Default Prevent printing of certain sheets

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
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
prevent certain cells from printing Wally Excel Discussion (Misc queries) 2 May 15th 10 10:39 PM
Prevent printing a sheet LindaC Excel Discussion (Misc queries) 3 January 13th 10 06:32 PM
Prevent Printing Steven Chan Excel Discussion (Misc queries) 4 September 20th 09 03:10 AM
Prevent Printing Pats Excel Programming 1 June 16th 09 06:59 AM
Prevent printing of some sheets and not others in a single doc? kblake Excel Programming 2 September 23rd 05 11:38 AM


All times are GMT +1. The time now is 05:07 PM.

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"