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....

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....

Macro1 is in the code for the Thisworkbook

Is'nt that were anything to run when opening is to be placed?

ctm

"NickHK" wrote in message
...
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....

Sorry i made a mistake.
Macro1 is in the code for Sheet2.

AHHH

Thanks for the pointer.
I moved it to a Module and it now is fine.

Thanks
Corey....



....
"NickHK" wrote in message
...
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....

Hi Corey,

Where is Macro1 housed?


---
Regards,
Norman


"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....