Have the macro run automatically
 

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

--
jenh
-----------------------------------------------------------------------
jenhu's Profile: http://www.excelforum.com/member.php...fo&userid=2896
View this thread: http://www.excelforum.com/showthread.php?threadid=52774

Have the macro run automatically
 

Hi jenhu

Call macroname
Or name your macro "auto_open"

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


--
Regards Ron de Bruin
http://www.rondebruin.nl


"jenhu" wrote in message
...

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

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

ANY SUGGESTIONS???

Thank you.


--
jenhu
------------------------------------------------------------------------
jenhu's Profile: http://www.excelforum.com/member.php...o&userid=28969
View this thread: http://www.excelforum.com/showthread...hreadid=527748