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:


Private Sub Workbook_Open()
call MyMacro
End Sub


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