BeforePrint event

[Guest]

I have the following macro in Excel 2003:

Private Sub workbook_BeforePrint(Cancel As Boolean)
Cancel = True
End Sub

The aim is to prevent printing. It does not seem to do anything but I don't
know why. Can anyone help?

Thanks

Dave

 

[Guest]

Have events been disabled - or macros disabled.

 

[Guest]

Macros are enabled and I think events are enabled:

Med = Application.EnableEvents

results in True.

 

[Guest]

If events work and macros are enabled bad that code is in the ThisWorkbook
module, I would expect that to block the printing of information in the
sheets of that workbook.