Posted to microsoft.public.excel.programming

Dave Shaw

external usenet poster

Posts: 21

BeforePrint event

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
BeforePrint Event - "PrintOut" does not give Print Dialog	Ronny Hamida	Excel Programming	2	October 11th 06 04:04 PM
printing macro,want to use beforeprint event?	paul	Excel Programming	1	July 2nd 06 08:05 PM
Execute code after printing with the BeforePrint event	mikeburg[_38_]	Excel Programming	1	October 2nd 05 06:27 AM
BeforePrint Event	Woody[_4_]	Excel Programming	2	July 20th 05 09:48 AM
BeforePrint event	EnglishTeacher	Excel Programming	4	October 13th 04 04:17 PM

All times are GMT +1. The time now is 07:08 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us