not quite true - Auto macros do not automatically run if the
workbook is opened from code.

Instead use the Worksheet_Open() event macro.

In article ,
wrote:

Try this

Sub Auto_Open()

Record macro as normal. Auto_Open will run everytime.


-----Original Message-----
How could I load a macro as soon as the workbook is
opened?
Thanks.
MJ Antoszkiw.
.