ExcelBanter - Load Macro at start up?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Load Macro at start up? (https://www.excelbanter.com/excel-programming/280813-load-macro-start-up.html)

No Name

Load Macro at start up?

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.
.

J.E. McGimpsey

Load Macro at start up?

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.
.

All times are GMT +1. The time now is 02:18 AM.