Disable print not working

  • Thread starter Thread starter acampbell012
  • Start date Start date
A

acampbell012

I am trying to disable printing via the menu or tool bar and I see this
response in a number of other posts. However it is not working for me.
Any thoughts? Thanks.

Alan


Private Sub Workbook_BeforePrint(Cancel As Boolean)
Cancel = True
End Sub
 
Did you put that code in the ThisWorkbook module?

Did you enable macros when you opened the workbook?

Did you ever disable events and not enable them later?
 
Dave

Dave said:
Did you put that code in the ThisWorkbook module? Yes.

Did you enable macros when you opened the workbook? Yes

Did you ever disable events and not enable them later? I tried this code in a workbook with no other code and it still failed to run. If I figure it out I will post back.
Thanks.

Alan
Click to expand...
 
Back
Top