Pop-up appearing when cell reaches a certain value

StuartOrd
StuartOrd used Ask the Experts™
on
I'm working in Excel 2003 on a workbook I've been given. When I alter some cell values I get a pop-up window containing a message and "Yes/No/Cancel" option buttons. I think it's triggered by a calculated cell Y4 exceeding a certain value. However I've looked in the macros and the VB editor and can't find any VB that gives this action. Can you please help me find it?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Can you provide us with the sheet?
JPIT Director

Commented:
Check the code modules for the Sheet name that you are working on. Look for code that is an On Change event.

Commented:
search virus infection

Author

Commented:
I can extract the sheet perhaps and upload it - the full workbook is confidential unfortunately,

In the VB editor, I can see the workbook which has a folder Microsoft Excel Objects, which contains all the sheets and one "This workbook". None of these have and code in the right hand window when I click them. There are no modules for this workbook.

It's not a virus, the message in the box is consistent with the job the orkbook was designed for.
Sorry, I've found it - it's a data validation entry. Thanks for your efforts
If you could extract the sheet and save it locally, then see if the functionality is there (ie the popup happens), if so post it here.

If not, maybe take copies of the original and keep deleting bits until the popup stops.  That may point to where it is coming from.

Author

Commented:
I found the cause before the experts - doesn't often happen!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial