Macro location

[Harald Staff]

In a standard module, name it Sub Auto_open() . Or you could use the
Workbook_open event in the ThisWorkbook module. See
http://www.cpearson.com/excel/events.htm
on more.

 

[Alan]

Where do I place a macro in the VB Editor to have it run every time the
workbook opens?

 

[Don Guillett]

In the ThisWorkbook module inside the Workbook_Open event

 

[Alan]

Thank you as usual!