Warning popup boxes

Copper Contributor

Gary_Stile2256_0-1631458376139.png

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

2 Replies

@Gary_Stile2256 

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: ..."

@Gary_Stile2256 

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.

 

NikolinoDE

What the answer useful? Mark them as helpful!

So you help all forum participants.