View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
WhytheQ WhytheQ is offline
external usenet poster
 
Posts: 246
Default 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