Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I need to be able to protect a range of cells on a worksheet. These cells have formulas in them, which will return a value based on what is entered in a particular cell. For example, if I enter the number 2 in cell A1, then A2 automatically displays "NEEDS ASSISTANCE" Whats been happening is, users have been clearing the contents of the sheet and erasing the formulas! My question is, what is the best way to protect the formulas, so the workbook still allow the functions to return values into the cells, but doesn't allow a user to change the formula? Hope that wasn't too confusing. Thanks all! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Protecting cells | Excel Discussion (Misc queries) | |||
Protecting Cells | Excel Discussion (Misc queries) | |||
Protecting Cells | Excel Discussion (Misc queries) | |||
Help with protecting cells | Excel Programming | |||
Protecting Cells | Excel Worksheet Functions |