MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Automatically execute a macro when Excel file is opened


Posted by NM on December 08, 2000 5:08 AM

Is there a way to automatically execute a macro when excel file is opened?

MyTest.xls has macros, Initialize(), DoCalculation(), Close(). When I open MyTest.xls file, it should automatically execute Initialize() macro.

How can this be done?

Thanks in advance,
-NM


Posted by Celia on December 08, 2000 5:57 AM


Change the name from Initialise to Auto_Open

Celia

Posted by Lokman Mat Lazim on December 08, 2000 10:00 AM

Its pretty easy

this is the code :

Private Subworkbook_open
Initialize
End Sub

hth

Change the name from Initialise to Auto_Open