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