Corey,
Where is "macro1" ? Public in a normal module ?

NickHK


"Corey" wrote in message
...
Sub Workbook_Open()
Worksheets("Sheet2").Select
Call Macro1
End Sub

I am getting an error of:

'Compile error:

Sub or Function not defined'




Yet if i manually run the macro it works fine??


Corey....