View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Valerie M Valerie M is offline
external usenet poster
 
Posts: 2
Default Code to auto update a footer

In Excel 2003 I have code in an Addin that inserts a document id into
the footer. Users run the code from a toolbar.

I need the code to automatically update itself when any workbook is
created, opened, saved or printed. If I put the event code (eg
Workbook_BeforeSave) into the addin, it only works for the addin
workbook. Is it possible to get the code to work for every workbook,
without having to add it to each workbook?