| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protecting select cells
Is there a way to protect a sheet, and its formulas, but only for a few cells
- for the 2003 version? for example: protected - f3 to f6, f8 unprotected - f2, f7 this way there are a few cells to imput data, and formulas in protected cells won't be accidentally deleted, causing problems for calculating... I appreciate the help! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Protecting select cells
Hi,
Select the cells you want to unprotect, then right click on the mouse, format cells, last tab Protection, uncheck locked. then protect your workbook If this helps please click yes, thanks "Derrick" wrote: Is there a way to protect a sheet, and its formulas, but only for a few cells - for the 2003 version? for example: protected - f3 to f6, f8 unprotected - f2, f7 this way there are a few cells to imput data, and formulas in protected cells won't be accidentally deleted, causing problems for calculating... I appreciate the help! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Protecting select cells
There are 2 aspects to protecting cell. First is locking the cells and second
is protecting the sheet. Locking Cells - One aspect of cell formatting is whether it is locked or not. You can access this property using Format - Cells... - Protection tab and toggle the Locked property. The locked property does nothing until the sheet is protected. What the locked property does is it specifies if the cell is allowed to be updated once the sheet is protected. So if a cell is locked and the sheet is protected then the user can not change the cell. This is how you want to treat your formulas. If a Cell is not locked and the sheet is protected the the user can change the cell. This is your input section. Protecting a Sheet activates the locks that you have in place. If a cell is not locked then protection does nothing to that cell. If ithe cell is locked then once protected the cell can not be updated. -- HTH... Jim Thomlinson "Derrick" wrote: Is there a way to protect a sheet, and its formulas, but only for a few cells - for the 2003 version? for example: protected - f3 to f6, f8 unprotected - f2, f7 this way there are a few cells to imput data, and formulas in protected cells won't be accidentally deleted, causing problems for calculating... I appreciate the help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Up down arrow keys do not select cells if select locked cells unch | Excel Discussion (Misc queries) | |||
| Macro to select cells without a certain value and select a menu it | Excel Worksheet Functions | |||
| Protecting select group of worksheets within a workbook | Excel Worksheet Functions | |||
| Using formulas to select cells (Ex: Select every nth cell in a col | Excel Discussion (Misc queries) | |||
| how do you "select locked cells" w/o "select unlocked cells"? | Excel Discussion (Misc queries) | |||
Hybrid Mode
