Ok, I know you can add an xls file to the XLStart folder and it will always load that first, and you can add code to run... but here is my problem

I Need to run code on every workbook that is opened.. The Autostart xls file is no good because it runs the code BEFORE the next workbook opens.

How can I run code on the workbook that is being opened? (Without having to code every workbook because that is not possible for this situation)

(basically I need to set the print options in excel for header/footer so that ever workbook prints the same)

Thanks!