ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Locked cell Change Message (https://www.excelbanter.com/excel-programming/437092-locked-cell-change-message.html)

Corey[_4_]

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




All times are GMT +1. The time now is 05:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com