Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protecting cell contents
I have about 5 cells on my sheet that contain formulas
which reference other sheets. I therefore want to prevent users from accidentally changing or deleting these 5 formulas. They are free to modify any other data on the sheet. How can I preserve these 5 cells which cointain formulas without using the "Protect Sheet" options??? BTW, users have the ability to protect and unprotect this sheet at any time with their own passwords, so it seems like I need another way to protect my formulas. I mean, once the user un-protects the sheet, they are able to delete anything and everything on the sheet, so I'm looking for another way to protect my specific cells. thank you! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protecting cell contents
Then You have to use macro to be enabled on the workbook and use your formula using selection change event |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protecting cell contents
Do you mean I need to use Worksheet_Change() to check if those
cells are changed?? is that all?? "Abdul" wrote in message ... Then You have to use macro to be enabled on the workbook and use your formula using selection change event |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protecting cell contents
Yes!
Put the formula back using code if that cell is changed Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
concatenate contents of cells whose contents resemble cell referem | Excel Worksheet Functions | |||
Change contents of a cell based on cell contents. | Excel Programming | |||
Macro to clear range contents when cell contents are changed by us | Excel Programming | |||
Macro to remove contents of cell and move all other contents up one row | Excel Discussion (Misc queries) | |||
Copying cell contents to add to existing contents in another cell | Excel Programming |