Is it possible to set up default Footer settings??
 

I already have an add-in which runs in the background and uses a class
that exposes the applications events.
This then does a couple of things like:
-warns me when excel has been switched to manual calculation by
accident
-puts the file pathway in Excel's title bar


Is it possible to set up more code so that for every new workbook it
sets a custom footer for every worksheet used ?? (....or maybe it is
possible to do this without using any code?)

Any help greatly appreciated.
Thanks,
Jason

Is it possible to set up default Footer settings??
 

Jason, design your new workbook with the desired footers and save the
file as book.xlt in Excel's startup folder. If you want each new added
sheet to have the same footer save a as sheet.xlt in the same folder.
HTH

Greg
WhytheQ wrote:
I already have an add-in which runs in the background and uses a class
that exposes the applications events.
This then does a couple of things like:
-warns me when excel has been switched to manual calculation by
accident
-puts the file pathway in Excel's title bar


Is it possible to set up more code so that for every new workbook it
sets a custom footer for every worksheet used ?? (....or maybe it is
possible to do this without using any code?)

Any help greatly appreciated.
Thanks,
Jason