Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
Unlock the cells you want users to be able to change. Then protect the sheet. To unlock cells: 1. Select the range 2. Format-Cells 3. In Protection tab, remove the check on the Lock checkbox -- Hope that helps. Vergel Adriano "G and (ajk)" wrote: How can you protect a range of cells (for example, Column A) with a password, but meanwhile allowing users to access all other cells on the sheet? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help!! Cell Protection | Excel Discussion (Misc queries) | |||
CELL PROTECTION | Excel Discussion (Misc queries) | |||
Cell Protection vs. Worksheet Protection | Excel Discussion (Misc queries) | |||
Cell Protection | Excel Worksheet Functions | |||
Cell protection | Excel Discussion (Misc queries) |