sheet protection - only selected range to be able to select/input data

[Corey]

if i select an array/range of cells, i want only those cells to be able to
be selected and/or data input into them.
But i did not want a popup msg to ask for a password, just a "DISABLED"
msgbox.
I want to prevent formulas being deleted .
How can i do this ?

 

[Gord Dibben]

Corey

By default all cells are locked when the sheet is protected.

Hit CRTL + A(twice if xl2003) then Format>Cells>Protection. Uncheck "locked"
and OK.

Select the cells you wish to lock and Format>Cells>Protection. Check "locked"
and OK.

Now Tools>Protection>Protect Sheet. This is mandatory.

You can set a password to unprotect the sheet. These can easily be broken in
Excel but will keep your formulas from being accidentally overwritten.

NOTE the options available in xl2002 and 2003 when you hit Protect Sheet

You can opt to "select unlocked cells" only.


Gord Dibben Excel MVP

if i select an array/range of cells, i want only those cells to be able to
be selected and/or data input into them.
But i did not want a popup msg to ask for a password, just a "DISABLED"
msgbox.
I want to prevent formulas being deleted .
How can i do this ?

Gord Dibben MS Excel MVP

 

[Corey]

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

 

[Corey]

Also,
How can i add CheckBoxes into the Not Protected cells ?

Corey....

 

[Gord Dibben]

Yes.

Just select the cells you want unlocked and Format>Cells>Protection. Uncheck
the "locked" option.

Now Protect the sheet.


Gord

 

[Corey]

thnx

Yes.

Just select the cells you want unlocked and Format>Cells>Protection.
Uncheck
the "locked" option.

Now Protect the sheet.


Gord

 

[Guest]

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]

If the cell is "locked" under Format>Cells>Protection it can also be "hidden".

Or don't allow users to select locked cells as Bob suggests in your other post.


Gord