Autorun macro

[MikeM]

Hi,

When I used Lotus a while ago, I remember (I think) being able to put
a macro named "auto.123" into a workbook and it would run as soon as
that workbook was opened... perhaps to open to a menu area of a sheet.

Does Excel have anything like that?

TIA

Mike

 

[Frank Kabel]

Hi
name the macro Auto_Open()

 

[Earl Kiosterud]

Mike,

This is done in the worksheet module, with Workbook_Open. If such a sub
exists, it is run at open time. There is also the older support for
automatically running any sub named Auto_Open, still supported for
compability.

 

[mike]

Thanks to all!