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