Thread: autorun macro
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
GB[_3_] GB[_3_] is offline
external usenet poster
 
Posts: 70
Default autorun macro


"hke" wrote in message
...
I want to have a macro run each time I open a new excel file based upon
a specific template. I saved the macro in the ThisWorkbook module of
the template, but still the macro has to be manually run for each new
file. Is there a way for new files to autorun the macro in their
ThisWorkbook module?


Is the macro called Workbook_Open() ?

GB