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