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

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?

Also, if the user doesn't have macros enabled then it will have no effect at all and the user can print away with no hint of
trouble.

--
RMC,CPA


"RVal" wrote in message ...
I am trying to stop anyone from printing a spreadsheet. Is this possible?

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?

In article ,
Abhishek kedia wrote:

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

Not sure I can explain in any more detail than my original reply...

- Did you put the code in the ThisWorkbook code module?

- Are macros enabled?

- Did you set a breakpoint in the code to see if it fired when you tried
to print?