Autorun macro

  • Thread starter Thread starter MikeM
  • Start date Start date
M

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