AutoRun Macros in a Workbook

[efinotti]

Dear Friends

Probably It is quite simple question, but I didn't get any answer using the formal ways, like helps files.

I would like to know, how to launch an macro automaticaly when a user opens an excel file?

Thanks in advance
Efinotti

 

[John McGraw]

On 2002-04-22 11:48, efinotti wrote:
Dear Friends

Probably It is quite simple question, but I didn't get any answer using the formal ways, like helps files.

I would like to know, how to launch an macro automaticaly when a user opens an excel file?

Thanks in advance
Efinotti

Go into VBA, click on the "This Workbook" module, and insert the following:<font size =-1>
Private Sub Workbook_Open()
call MyMacro
End Sub<font size =+.5>

For more help in the help files, do a search on "events".
This message was edited by John McGraw on 2002-04-22 13:01

 

[efinotti]

Thanks a lot John.

See you.

Efinotti