<div>
vtang,<br />
<br />
In Excel97 another way to do it is to go to the Visual Basic editor.<br />
<br />
Double click on ThisWorkbook on the left side.<br />
<br />
In the top left hand dropdown, where it says (General), select Workbook.<br />
<br />
The event listed in the right hand drop down should default to Open and a macro called Workbook_Open will be created. <br />
<br />
This subroutine will also autorun when the workbook is opened. Workbook_Open is the new method in Excel97. Auto_Open is from earlier versions but still works fine.<br />
<br />
Steve<br />

</div>


vtang,

In Excel97 another way to do it is to go to the Visual Basic editor.

Double click on ThisWorkbook on the left side.

In the top left hand dropdown, where it says (General), select Workbook.

The event listed in the right hand drop down should default to Open and a macro called Workbook_Open will be created.

This subroutine will also autorun when the workbook is opened. Workbook_Open is the new method in Excel97. Auto_Open is from earlier versions but still works fine.

Steve


<div>
Also something to be aware of that there is a registered Microsioft Bug with running more than one Auto_Open Macro from code. ie If you are opening sevberal books and are exectuing their Auto_Open macros, only the first one will be executed.<br />
<br />
Regs<br />
<br />
Steve<br />

</div>


Also something to be aware of that there is a registered Microsioft Bug with running more than one Auto_Open Macro from code. ie If you are opening sevberal books and are exectuing their Auto_Open macros, only the first one will be executed.

Regs

Steve


<div>
<div class="content wysiwyg-content">
Need to run a macro automatically after opening an Excel 97 Workbook.<br />
<br />
Any suggestion?<br />
<br />
Thanks
</div>
</div>


Need to run a macro automatically after opening an Excel 97 Workbook.

Any suggestion?

Thanks

Auto Run an Excel macro After opening a Workbook

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.