![]() |
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