Avatar of StuartOrd
Flag for United Kingdom of Great Britain and Northern Ireland asked on

Pop-up appearing when cell reaches a certain value

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?
Microsoft Excel

Avatar of undefined
Last Comment

8/22/2022 - Mon

Can you provide us with the sheet?

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

search virus infection
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck

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.

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question

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.

I found the cause before the experts - doesn't often happen!
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.