Posted to microsoft.public.excel.programming

Wayne

external usenet poster

Posts: 133

Workbook_BeforePrint

I'm trying to produce a footer before the printing.
I've tried putting this into a module and also into the sheet1 code area.

Any ideas wy it will not work?

Private Sub Workbook_BeforePrint(Cancel As Boolean)
Application.EnableEvents = False
Cancel = True
Worksheets("Sheet1").PageSetup.RightFooter = "Produced by MyName"
Application.EnableEvents = True

End Sub

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
How store PageBrakes locations - Coded pagebrakes are deleted in Workbook_BeforePrint	Marie J-son[_6_]	Excel Programming	1	May 8th 05 02:49 PM
Workbook_BeforePrint performs twice ?	Peter[_21_]	Excel Programming	3	November 29th 04 01:24 AM
disable print option, not Workbook_BeforePrint	Andoni[_4_]	Excel Programming	0	July 27th 04 11:40 PM
Workbook_BeforePrint	Squid[_2_]	Excel Programming	2	May 11th 04 04:18 PM
Problem - Workbook_BeforePrint	JON-JON	Excel Programming	3	August 26th 03 01:19 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us