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

Have events been disabled - or macros disabled.

--
regards,
Tom Ogilvy


"Dave Shaw" wrote:

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

Macros are enabled and I think events are enabled:

Med = Application.EnableEvents

results in True.


"Tom Ogilvy" wrote:

Have events been disabled - or macros disabled.

--
regards,
Tom Ogilvy


"Dave Shaw" wrote:

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

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.

--
Regards,
Tom Ogilvy


"Dave Shaw" wrote:

Macros are enabled and I think events are enabled:

Med = Application.EnableEvents

results in True.


"Tom Ogilvy" wrote:

Have events been disabled - or macros disabled.

--
regards,
Tom Ogilvy


"Dave Shaw" wrote:

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