Is there anyway to do the following.

I have 2 sheets

Sheet1
Sheet2

Most of the time I am in Sheet1

However Sheet1 is dependent on Sheet2


In column J on Sheet2 it can say

1. wait for purchase order
2. reschedule too many
3. blank(nothing)

What I want the workbook change to do is if any cell in column j on
Sheet2 = wait for purchase order then have a msgbox pop up

If any cell in column j on Sheet2 = reschedule too many, then another
msg box to pop up with different caption.

If blank, nothing.

Is there anyway that once it warns you for a specific cell, that you
can cancel the warning. My problem is that the msg box keeps popping
up, even though it already warned you once.

Thanks for any help

Josh


--
jhahes
------------------------------------------------------------------------
jhahes's Profile: http://www.excelforum.com/member.php...o&userid=23596
View this thread: http://www.excelforum.com/showthread...hreadid=385311