Prevent Printing

[Steven Chan]

When I password protect my shared worksheet, it is possible to also prevent
the worksheet from being printed. Please adz.

 

[Dave Peterson]

You could stop printing with an event macro, but macros and events can be
disabled.

So the answer is not really.

 

[Gord Dibben]

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

 

[Steven Chan]

Yes, to share a workbook not worksheet. Tried as recommended and it work,
Thanks.

Steven Chan

 

[Gord Dibben]

Thanks for the feedback.


Gord

Yes, to share a workbook not worksheet. Tried as recommended and it work,
Thanks.

Steven Chan