Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
BeforePrint Event
HI,
I am trying to develop some VBA code in excel 2003 that will automatically place a specific header and footer on any sheet I print from excel. So far I have created the following code in my personal workbook. Public Sub App_WorkbookBeforePrint(Cancel As Boolean) ActiveSheet.PageSetup.RightFooter = "&D &T" ActiveSheet.PageSetup.CenterFooter = "&F" End Sub It appears to work for that workbook but not others I have open. Can anyone suggest how I can make this code apply to the excel application instead of to a particular workbook? Thanks, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
BeforePrint macro | Excel Discussion (Misc queries) | |||
BeforePrint Add In | Excel Programming | |||
ADO 2.7 & ADO 2.8 beforeprint | Excel Programming | |||
BeforePrint event | Excel Programming | |||
Help with BeforePrint | Excel Programming |