Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Locked cell Change Message
I have a spread sheet that i use that has many formula's on it.
I have the cells with formula's set to Locked, so that they are not accidently deleted or modified by a user. But i have found occasionally, somehow, a cell that is Locked and contains a formula, is deleted. There is times when macro's are run to Protect/Unprotect the sheet, but think a user may have unprotected the sheet manually somehow, and accidently deleted the formula. My question is, Is it possible to have a Prompt, or Message Box come up to Indicate that a Locked Cell that contained a Formula has been modified? If so how can i do this? Would it ben in the Worksheet_Change event? Corey.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
show a customised message when a trying to edit a locked cell | Excel Worksheet Functions | |||
change locked cell if | Excel Discussion (Misc queries) | |||
Relacing default Excel message box when user attempts to change locked cell on protected sheet. | Excel Programming | |||
How do I add a balloon message to a locked cell | Excel Discussion (Misc queries) | |||
Customizing the Locked Cell Warning Message Box | Excel Programming |