mass changes to cell protection

A

Adam Kroger

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.
 
P

Paul B

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
 
A

Adam Kroger

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

Adam
 
G

Gord Dibben

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.

Format>Cells>Protection. Change to "unlocked" by clicking the checkmark out
of the option box. OK out.

Hit F5>Special>Formulas>OK

All cells with formulas are selected.

Format>Cells>Protection. Changed to "Locked". OK out.

Now Tools>Protection>Protect sheet>OK

Give a password or not.


Gord Dibben Excel MVP
 
A

Adam Kroger

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

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