View Single Post
  #2   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

On Friday, February 9, 2018 at 9:44:48 AM UTC, Paul Martin wrote:
I have sheets that are OK to be viewed but not OK to be printed. Using the Workbook_BeforePrint event, I can turn off screen updating, hide the sheets not to be printed, then print out, but then the sheets are hidden. Can anyone offer a solution to this? TIA


I'm using Excel 2016