View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default cell protection, how to?

Try it in this sequence ..

First, you need to "unlock" all cells in the sheet. Select the entire sheet,
click Format Cells Protection tab Uncheck "Locked" OK.

Now select only the cells that you want protected (Hold down CTRL to select
multiple cells/ranges). Click Format Cells Protection tab Check
"Locked" OK.

Then apply sheet protection via Tools Protection Protect Sheet
Password? OK
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"S S" wrote:
How do I protect selected cells for protection in a worksheet?
I have gone to tools and protection but can only seem to protect the full
worksheet, I have tried clicking/unclicking locked and unlocked boxes but
cant seem to get it right.