Since there is no global template for Excel2002 and
PowerPoint 2002, can anyone tell How to get a macro
running automatically when Excel/PowerPoint 2002 is
initiated? Thanks.
AFAIK, there isn't. The closest one can get is to put a workbook in
the startup folder (for XL) that has a 'workbook_open' event procedure
that does what you want. This leverages the fact that XL will open all
workbooks in the startup folder at, well, at startup.
Unfortunately, no equivalent solution for PP comes to mind.
It might be better to write an add-in (a solution that should work with
all, or at least most, MS Office products) since the add-in will be
loaded by the program at startup (well, except if the program is
initiated by OLE in which case, assuming I remember correctly, add-ins
are not automatically loaded).
--
Regards,
Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
