| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Customized worksheet security
How can I keep others from editing certain columns in a worksheet WITHOUT
securing the entire worksheet. Can I do it w/o the other person having to enter a password to edit unprotected cells? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Customized worksheet security
When worksheet protection is applied, it is only applied to *locked* cells.
Lock the cells you want protected and unlock the cells you want unprotected (Format/Cells/Protection). Note that worksheet protection is very weak and won't stop anyone with intent from unprotecting the sheet, but it is good for keeping users from accidently modifying/overwriting things they should not be. "rldjda" wrote: How can I keep others from editing certain columns in a worksheet WITHOUT securing the entire worksheet. Can I do it w/o the other person having to enter a password to edit unprotected cells? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Consulting Access from Excel | Excel Discussion (Misc queries) | |||
| How:Add New Worksheet that copies the cell of the previous sheet | Excel Worksheet Functions | |||
| Retrieve data from all of the worksheet within the file | Excel Worksheet Functions | |||
| Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
| Weekly Transaction Processing | Excel Worksheet Functions | |||
Linear Mode
