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.

Steven Chan wrote:

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

--

Dave Peterson

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

On Sat, 19 Sep 2009 10:55:02 -0700, Steven Chan
wrote:

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

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

Steven Chan


"Gord Dibben" wrote:

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

On Sat, 19 Sep 2009 10:55:02 -0700, Steven Chan
wrote:

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

Thanks for the feedback.


Gord

On Sat, 19 Sep 2009 17:03:02 -0700, Steven Chan
wrote:

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

Steven Chan


"Gord Dibben" wrote:

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

On Sat, 19 Sep 2009 10:55:02 -0700, Steven Chan
wrote:

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