Prevent Printing

  • Thread starter Thread starter Steven Chan
  • Start date Start date
S

Steven Chan

When I password protect my shared worksheet, it is possible to also prevent
the worksheet from being printed. Please adz.
 
You could stop printing with an event macro, but macros and events can be
disabled.

So the answer is not really.
 
You cannot share a worksheet.

You can share a workbook.

Do you want to prevent the shared workbook or any sheet therein from being
printed?

You could use beforeprint event code to cancel any printing but macros would
have to be enabled.

Private Sub Workbook_BeforePrint(Cancel As Boolean)
MsgBox "you are not allowed to print"
Cancel = True
End Sub

First you must unshare the workbook.

Paste the code into Thisworkbook module.

Re-share the workbook, which saves it.


Gord Dibben MS Excel MVP
 
Yes, to share a workbook not worksheet. Tried as recommended and it work,
Thanks.

Steven Chan
 
Back
Top