Warning popup boxes

Occasional Contributor


How do I prevent this from popping up. This happens when I go from 1 tab to another.

2 Replies


That is most probably the result of VBA code.

In the Visual Basic Editor (Alt+F11), check the code modules of the worksheets and the ThisWorkbook module to see if you can find code that displays a message box:


MsgBox "WARNNING: ..."


Highlight the cell in question and go to Data -> Data Review.

There you can go to the "Error Message" tab under "Type" instead of "Stop" select "Information" or "Warning".

If you see an error message above at "if invalid value is entered "remove the checkmark, you can enter any value without an error message.


More infos in this Link: More on data validation



Hope I was able to help you with this information / links.



What the answer useful? Mark them as helpful!

So you help all forum participants.