How do you execute a macro automatically?....

[Marcial]

Folks I'm new creating excel macros, I have a
question...I am using ms excel 97 and I created a macro in
my excel file, but I want this macro to be executed
automatically every time I open this excel file, How can I
do this? Thank you for your help.

 

[Frank Kabel]

Hi
you can either put this macro in the workbook_open event of your
workbook (see http://www.cpearson.com/excel/events.htm for more info
about event procedures)
or name your macro Auto_Open()

 

[Marcial]

So easy!!
Thank you very much!Frank!!

-----Original Message-----
Hi
you can either put this macro in the workbook_open event of your
workbook (see http://www.cpearson.com/excel/events.htm for more info
about event procedures)
or name your macro Auto_Open()

--
Regards
Frank Kabel
Frankfurt, Germany


.