How to disable printing a specific worksheet?

E

Efzed

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.
 
J

JE McGimpsey

You could use a Workbook_BeforePrint() event macro to intercept print
commands and skip printing the particular sheet. However,

(a) Setting security to High or not enabling macros when opening the
workbook will bypass the event macro

(b) the event macro won't prevent printing a screen shot

(c) the event macro won't prevent copying the data to a new workbook and
printing that workbook.

So unless you're just trying to save paper, it's largely an exercise in
futility.
 
Top