View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Corey Corey is offline
external usenet poster
 
Posts: 276
Default sheet protection - only selected range to be able to select/input data

thnx

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Yes.

Just select the cells you want unlocked and FormatCellsProtection.
Uncheck
the "locked" option.

Now Protect the sheet.


Gord

On Fri, 17 Nov 2006 12:28:03 +1100, "Corey"

wrote:

Thank You Gord.

As the majority of the cells i need to have locked,
it is possible to select the few cell to be Unlocked, then REVERSE the
selection somehow.
(Invert: So all selected are Not Selected, and all not selected ar now
Selected) ?