Yes/No MsgBox looping if No selected

First, I hope I am posting this correctly as this is my first post.


I'm trying to set this condition for various ranges of my worksheet to bring up a warning when anyone has entered data into a section they should not be altering. The warning should give them the option accept their changes or cancel which undo's the entry prompting the warning. The VBA below works great if you hit Yes, but it you hit no it undo's the entry but continues to loop the warning until you hit Yes. Any advice?

Please Login or Register  to view this content.

You could try this:

Please Login or Register  to view this content.

BSB

Perfect, that nailed it! Thanks for the quick help!

No problem at all. Happy to help.

BSB