Need a loud/bright warning before making changes.
 

My son has a severe handicap with his short term memory. I have made a spread
sheet so that he can do some limited work for my business. He does ok, except
for there is one thing that he needs to do before he changes some validation
lists on the page, and I can't get him to remember to do it. Is there some
way that before he selects an option from a validation list I can have some
form of lock or warning that will remind him before he selects it. Like a
lock, with a message? So that he can't change the list without selecting a
button? I have fair skills, but I can't find a solution to this problem.

Thank you for any help you may have.

Need a loud/bright warning before making changes.
 

Sheet protection might work. Select all the cells that he is allowed to
change and go to FormatCells and under the "Protection Tab" uncheck
'locked' and OK out. Then go to the ToolsProtectionProtect Sheet (you can
put a password in at this point but it's not necessary and probably
counterproductive in your case)

Now he will be able to change any unlocked cell but if he attempts to change
a locked cell he will get a message saying that the sheet is locked and must
be unlocked before changing the cell. To unlock the cell go to
ToolsProtectionUnprotect Sheet. It's still a bit messy cause you then have
to get him to remember to protect the sheet again after he is finished, but
you might be able to sort something out.

It's a handy tool, I sometimes have to protect sheets from myself cause I do
have a tendancy to get ahead of myself at times which can create the odd
minor dilemna.

HTH
Martin