| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you prevent users from changing certain cells?
I would like to allow users to change certain cells but not the formulas in
other cells. The "Protection" feature doesn't prevent someone from changing one of the cells with formulas. Thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do you prevent users from changing certain cells?
Kelly
It sounds like the cell you refer to is not formatted for protection. Try: Tools Protection Unprotect sheet Format Cells Protection tab 'click' on box against Locked to enter tick Tools Protection Protect sheet This should ptotect said cell "Kelly" wrote: I would like to allow users to change certain cells but not the formulas in other cells. The "Protection" feature doesn't prevent someone from changing one of the cells with formulas. Thanks. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do you prevent users from changing certain cells?
The protection feature for the workbook works in connection with Format/
Cells/ Protection to allow you to lock or unlock particular cells, and thus govern whether users can change the cell contents. If the cell is locked and the sheet protected, the formula can't be changed. -- David Biddulph "Kelly" wrote in message ... I would like to allow users to change certain cells but not the formulas in other cells. The "Protection" feature doesn't prevent someone from changing one of the cells with formulas. Thanks. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do you prevent users from changing certain cells?
format the cell with the formula using the protection tab and locked and
hidden checked. Do the opposite to all the remaining cells. ToolsProtectworksheet make sure the "select locked cells" is not checked Not only can't the cell with the formula be changed but now the formula is not visible and the user can not click into the cell. "Kelly" wrote: I would like to allow users to change certain cells but not the formulas in other cells. The "Protection" feature doesn't prevent someone from changing one of the cells with formulas. Thanks. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do you prevent users from changing certain cells?
or you can use data validation to "lock" a cell here & there (if your
users won't know how to unlock it). just choose custom & then in the formula i use =0 (so anything they enter is "wrong"), & then in the error alert i choose "stop" with a message that says "Formula cell. No manual entry allowed!" just an idea susan On Mar 12, 1:10*pm, "David Biddulph" <groups [at] biddulph.org.uk wrote: The protection feature for the workbook works in connection with Format/ Cells/ Protection to allow you to lock or unlock particular cells, and thus govern whether users can change the cell contents. *If the cell is locked and the sheet protected, the formula can't be changed. -- David Biddulph "Kelly" wrote in message ... I would like to allow users to change certain cells but not the formulas in other cells. *The "Protection" feature doesn't prevent someone from changing one of the cells with formulas. Thanks.- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Prevent users from changing a pivot table | New Users to Excel | |||
| Prevent users from changing the password | Excel Discussion (Misc queries) | |||
| How to prevent users from changing cell format | Excel Discussion (Misc queries) | |||
| Prevent Users from Selecting Cells | Excel Worksheet Functions | |||
| how do I prevent users to go into locked cells | Excel Discussion (Misc queries) | |||
Linear Mode
