Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy / Paste Warning | Excel Discussion (Misc queries) | |||
Warning while entering duplicate values in a cell | Excel Discussion (Misc queries) | |||
Macro warning box | Excel Discussion (Misc queries) | |||
How to turn off warning when hyperlinking to other program? | Excel Discussion (Misc queries) | |||
Macro warning (upon opening) | Excel Discussion (Misc queries) |