Disable a cell

  • Thread starter Thread starter Pats
  • Start date Start date
P

Pats

Please can someone assist me on how to disable some cells to preven
users making any changes on that sheet. I am using Excel 2000. Th
protection option prevents user to not enter anything at all but I jus
want certain cells to be disable ....i.e. not to be change/modify b
anyone.
Appreciate any idea
 
Hi Pat

All cells are locked by default and when the sheet is protected these
cells cannot be used. Try this

Push Ctrl+A to select all cells.
Go to Format>Cells>Protection and uncheck Locked and click OK.
Now select the cell that should be "Locked" (try Edit>Go to - Special
for this) and go to Format>Cells>Protection and *check* Locked and click
OK.
Now protect the sheet.



***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****
 
Back
Top