mass changes to cell protection
 

Is there a way to alter the cell protection based on a condition instead of
going in and manually changing them?

more exact: I want to protect all my cells that have a formula, and
un-protect the ones that do not.

mass changes to cell protection
 

Adam, on way, select all the cells, Ctrl+a, unprotect them all, then edit,
go to, special, check formulas ok, then protect the cells that are selected

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Adam Kroger @hotmail.com" <adam_kroger<nospam wrote in message
. ..
Is there a way to alter the cell protection based on a condition instead
of
going in and manually changing them?

more exact: I want to protect all my cells that have a formula, and
un-protect the ones that do not.

mass changes to cell protection
 

Paul:
I am using Excel97 (probably should have mentioned that) will they still
work for me? I did try, but <CTRLA did not do anything, and I do not know
where the "Special" feature is.

Adam

"Paul B" wrote in message
...
Adam, on way, select all the cells, Ctrl+a, unprotect them all, then edit,
go to, special, check formulas ok, then protect the cells that are
selected

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Adam Kroger @hotmail.com" <adam_kroger<nospam wrote in message
. ..
Is there a way to alter the cell protection based on a condition instead
of
going in and manually changing them?

more exact: I want to protect all my cells that have a formula, and
un-protect the ones that do not.

mass changes to cell protection
 

Adam

Hold CTRL key down and hit the "a" key on keyboard.

Alternative.....click on the gray rectangle at top left corner of the row and
column headers.

Either method will select all cells.

FormatCellsProtection. Change to "unlocked" by clicking the checkmark out
of the option box. OK out.

Hit F5SpecialFormulasOK

All cells with formulas are selected.

FormatCellsProtection. Changed to "Locked". OK out.

Now ToolsProtectionProtect sheetOK

Give a password or not.


Gord Dibben Excel MVP

On Thu, 24 Nov 2005 10:45:48 -0600, "Adam Kroger"
wrote:

Paul:
I am using Excel97 (probably should have mentioned that) will they still
work for me? I did try, but <CTRLA did not do anything, and I do not know
where the "Special" feature is.

Adam

"Paul B" wrote in message
...
Adam, on way, select all the cells, Ctrl+a, unprotect them all, then edit,
go to, special, check formulas ok, then protect the cells that are
selected

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Adam Kroger @hotmail.com" <adam_kroger<nospam wrote in message
. ..
Is there a way to alter the cell protection based on a condition instead
of
going in and manually changing them?

more exact: I want to protect all my cells that have a formula, and
un-protect the ones that do not.

mass changes to cell protection
 

Thanks for the step-by, it cleared up my haze.

Adam Kroger: Excel MoLC < More or Less Confused ;-)

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

Hold CTRL key down and hit the "a" key on keyboard.

Alternative.....click on the gray rectangle at top left corner of the row
and
column headers.

Either method will select all cells.

FormatCellsProtection. Change to "unlocked" by clicking the checkmark
out
of the option box. OK out.

Hit F5SpecialFormulasOK

All cells with formulas are selected.

FormatCellsProtection. Changed to "Locked". OK out.

Now ToolsProtectionProtect sheetOK

Give a password or not.


Gord Dibben Excel MVP

On Thu, 24 Nov 2005 10:45:48 -0600, "Adam Kroger"
wrote:

Paul:
I am using Excel97 (probably should have mentioned that) will they still
work for me? I did try, but <CTRLA did not do anything, and I do not
know
where the "Special" feature is.

Adam

"Paul B" wrote in message
...
Adam, on way, select all the cells, Ctrl+a, unprotect them all, then
edit,
go to, special, check formulas ok, then protect the cells that are
selected

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Adam Kroger @hotmail.com" <adam_kroger<nospam wrote in message
. ..
Is there a way to alter the cell protection based on a condition
instead
of
going in and manually changing them?

more exact: I want to protect all my cells that have a formula, and
un-protect the ones that do not.

mass changes to cell protection
 

Thanks for the feedback Adam

Gord

On Thu, 24 Nov 2005 14:41:11 -0600, "Adam Kroger"
wrote:

Thanks for the step-by, it cleared up my haze.

Adam Kroger: Excel MoLC < More or Less Confused ;-)

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

Hold CTRL key down and hit the "a" key on keyboard.

Alternative.....click on the gray rectangle at top left corner of the row
and
column headers.

Either method will select all cells.

FormatCellsProtection. Change to "unlocked" by clicking the checkmark
out
of the option box. OK out.

Hit F5SpecialFormulasOK

All cells with formulas are selected.

FormatCellsProtection. Changed to "Locked". OK out.

Now ToolsProtectionProtect sheetOK

Give a password or not.


Gord Dibben Excel MVP

On Thu, 24 Nov 2005 10:45:48 -0600, "Adam Kroger"
wrote:

Paul:
I am using Excel97 (probably should have mentioned that) will they still
work for me? I did try, but <CTRLA did not do anything, and I do not
know
where the "Special" feature is.

Adam

"Paul B" wrote in message
...
Adam, on way, select all the cells, Ctrl+a, unprotect them all, then
edit,
go to, special, check formulas ok, then protect the cells that are
selected

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Adam Kroger @hotmail.com" <adam_kroger<nospam wrote in message
. ..
Is there a way to alter the cell protection based on a condition
instead
of
going in and manually changing them?

more exact: I want to protect all my cells that have a formula, and
un-protect the ones that do not.