C
Corey
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....
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....