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