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

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 ?

--
Regards

Corey

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

Corey

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

Hit CRTL + A(twice if xl2003) then FormatCellsProtection. Uncheck "locked"
and OK.

Select the cells you wish to lock and FormatCellsProtection. Check "locked"
and OK.

Now ToolsProtectionProtect 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

On Fri, 17 Nov 2006 11:19:46 +1100, "Corey"
wrote:

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

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

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

--
Regards

Corey


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

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

Hit CRTL + A(twice if xl2003) then FormatCellsProtection. Uncheck
"locked"
and OK.

Select the cells you wish to lock and FormatCellsProtection. Check
"locked"
and OK.

Now ToolsProtectionProtect 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

On Fri, 17 Nov 2006 11:19:46 +1100, "Corey"

wrote:

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

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

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

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

--
Regards

Corey


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

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

Hit CRTL + A(twice if xl2003) then FormatCellsProtection. Uncheck
"locked"
and OK.

Select the cells you wish to lock and FormatCellsProtection. Check
"locked"
and OK.

Now ToolsProtectionProtect 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

On Fri, 17 Nov 2006 11:19:46 +1100, "Corey"

wrote:

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

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

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

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

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

sheet protection - only selected range to be able to select/in
 

If the cell is "locked" under FormatCellsProtection it can also be "hidden".

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


Gord

On Tue, 13 Feb 2007 05:11:01 -0800, sansk_23
wrote:

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