S Steven Chan Sep 19, 2009 #1 When I password protect my shared worksheet, it is possible to also prevent the worksheet from being printed. Please adz.
When I password protect my shared worksheet, it is possible to also prevent the worksheet from being printed. Please adz.
D Dave Peterson Sep 19, 2009 #2 You could stop printing with an event macro, but macros and events can be disabled. So the answer is not really.
You could stop printing with an event macro, but macros and events can be disabled. So the answer is not really.
G Gord Dibben Sep 19, 2009 #3 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
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
S Steven Chan Sep 20, 2009 #4 Yes, to share a workbook not worksheet. Tried as recommended and it work, Thanks. Steven Chan
G Gord Dibben Sep 20, 2009 #5 Thanks for the feedback. Gord Yes, to share a workbook not worksheet. Tried as recommended and it work, Thanks. Steven Chan Click to expand...
Thanks for the feedback. Gord Yes, to share a workbook not worksheet. Tried as recommended and it work, Thanks. Steven Chan Click to expand...
