Excel Disable Printing

[karldenton]

Hi

I have an Excel worksheet that I want to disable printing on. I have tired the following macro but still prints

 

Private Sub Workbook_BeforePrint(Cancel As Boolean)

Cancel = True

End Sub

 

[Steve21]

Where did you add the macro? If it's not added to the workbook module it wouldn't actually get called by default. (And obviously if the excel file is opened without macro's it won't work either)

 

Steve

[karldenton]

It down as module6 in Excel.

Does it need to be Private Sub or just Sub.

[karldenton]

Sorted it. As said above, put it into the worksheet rather than a module and is spot on