Hi
you have to place this code in your workbook module ('ThisWorkbook').
Also you should add the sheet name to your refeerence. e.g.
IF worksheets("sheet1").cells(10,2)0 then

--
Regards
Frank Kabel
Frankfurt, Germany


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 not
work when I open this work book. I want when ever I open workbook
and
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/