ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How to disable printing a specific worksheet? (https://www.excelbanter.com/excel-worksheet-functions/131669-re-how-disable-printing-specific-worksheet.html)

William Horton

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.



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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com