Thread: Cell protection
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default 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?