Call subroutine

[AAAAndy]

I'm trying to call a subroutine on one sheet from a different sheet in the same workbook. What am I missing? The example bellow works when the subs are on the same page. I tried inserting in Sub Test1 a line selecting the worksheet in which Test2 resides, but that didn't work.

Sub Test1()
Call Test2
End Sub

Sub Test2()
Msgbox "Test2"
End Sub

 

[Datsmart]

Sounds like your macros are in Sheet Modules, try them from Standard Modules.

 

[AAAAndy]

That helps. Thanks a LOT!