Have the macro run automatically

[jenhu]

I have a macro - module1 () that we can run it manually.

Now I want to have the macro run automatically when the workbook open
so I add workbook_open()
--------------------------------
Private Sub Workbook_Open()
call module1
End Sub
-------------------------------
However, when I open the workbook again, nothing happens, I still nee
to run the macro manually.....

ANY SUGGESTIONS???

Thank you

 

[Ron de Bruin]

Hi jenhu

Call macroname
Or name your macro "auto_open"

See also
http://www.cpearson.com/excel/events.htm