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

C

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

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 ?
Click to expand...

Gord Dibben MS Excel MVP
 
C

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

Gord Dibben

Yes.

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

Now Protect the sheet.


Gord
 
S

sansk_23

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
 
Top