autoexecute macros on open or new
How to execute macros on File / New or File / Open in
Excel XP ?
So far I have found that if I will put the procedure named
Workbook_Open in ThisWorkbook it works. But I would like
to have two different actions executed on Open and on New.
Should I name them Workbook_Open and Workbook_New and have
them stored in ThisWorkbook ? Or is there any way to have
them as a modules with some specific names ?
Regards,
Tony
|