View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Paul Martin[_2_] Paul Martin[_2_] is offline
external usenet poster
 
Posts: 133
Default Prevent printing of certain sheets

One option I'm contemplating is forcing the user to use a custom print button, called from Workbook_BeforePrinting, whereby Cancel = False if called from the button, or Cancel = True if called from Control P or the Excel Print commands. Can anyone confirm whether this is possible? TIA...