View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Abhishek kedia
 
Posts: n/a
Default protect a sheet from being printed?


Hi
JE McGimpsey

I tried it, but unforunitly it does not work, can u explain in detail

Thanks

Abhishek kedia
"JE McGimpsey" wrote:

Prevent? Yes, it's impossible.

Make it somewhat difficult for a novice user? Sure. Put this in the
ThisWorkbook module of your workbook:


Private Sub Workbook_BeforePrint(Cancel As Boolean)
Cancel = True
End Sub

However, this will not prevent anyone from printing a screenshot.


In article ,
RVal wrote:

I am trying to stop anyone from printing a spreadsheet. Is this possible?