View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
William Horton William Horton is offline
external usenet poster
 
Posts: 96
Default How to disable printing a specific worksheet?

I think you would need a macro to do that. You would have to place the macro
in the "BeforePrint" event which is in the "ThisWorkbook" sheet/folder. You
could say something to the affect that if the sheet name is "yoursheetname"
to cancel the print request. However, you may also have to do something if
the user is on another sheet and asks to print the entire workbook from the
File/Print menu. Try posting the question in the Programming discussion
group.

Hope this helps.

Bill Horton

"Efzed" wrote:

I want to know if there is any way where even if you click the PRINT icon in
excel, the particular worksheet will not print. In other words, I want to
restrict printing a worksheet in a workbook.