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.