Cell protection
Select all cells
Goto CellsFormatProtection and uncheck the Locked Box, then OK
Select JUST the cells to protect
Goto CellsFormatProtection and CHECK the Locked Box, then OK
Goto ToolsProtection and set a worksheet password.
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"G and (ajk)" wrote in message
...
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?
|