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?
|