I am trying to have a msgbox in case B10 is greater than 0 (Zero)...

Sub workbook_open()

If Cells(10, 2) 0 Then
msg = MsgBox("Need investigation.... ", vbOKOnly, "Money Missing")
End If

End Sub

However, this code runs very well when i play from VBE but does no
work when I open this work book. I want when ever I open workbook an
B10 is greater than 0 then it should give me this message...
I neeeeeed badly you help please..

--
Message posted from http://www.ExcelForum.com