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) ?
|