Application-defined or object-defined error

[macrofan]

I tried to call a procedure when the workbook opens, the code is like this:

Private Sub Workbook_Open()
Call Sheet1.BollingerBand
Call Sheet3.Candle
End Sub

However, the program stops at first call with a meesage of "Application-defined or object-defined error".

If I delete the line for the first call, no error message. And now if I run the procedure of "BollingerBand" within the workbook, everything is working.

My qauestion is why I can run the procedure but just couldn't call it.

Thanks for yhour reply!

 

[macrofan]

Having not tried calling 2 sheet subs from different sheets in the same workbook before I wouldn't attempt to speculate.

I have always done what your friend suggested and put multiple subs in std module/s and called them exactly as Hiker95 has suggested

OK. I should try to call them as modules.