autorun macro on opening workbook

[Donna]

Hi

I want to write a macro in VB that will automatically run when you open up the workbook it lives in. (Like AutoExec in Access)

Is this possible? If so how do I do it?

Thanks in advance

Donna

PS I am talking about an Excel workbook.

[ortizmro]

All you do is name the macro Auto_Open. So however you create it, just go to the macro with Alt + F8, click on desired macro, then click on Edit, then just change the name line to:

Sub Auto_Open()

MRO

[Donna]

Thanks for your help.

:D