sheet protection - only selected range to be able to select/in
Hi !! How can i hide the formula in a particular cell - if i dont want the
user to view the formula that has been specified in that cell ?
thx & regards
Sanjay Kapoor
"Gord Dibben" wrote:
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) ?
|