Finding and locking formula cells

[Louise]

Hi all

I've done this before but can't remember how.......

I want Excel to find all the cells on a worksheet / workbook and lock them,
to prevent users from editing the cells. I know how to protect cells from
being edited, however, I can't remember the quick way to find all the cells
containing formulas.

Can anybody help?

Thank you.

Louise

 

[ShaneDevenshire]

Hi,

F5, Special, Formulas

 

[Louise]

Thank you.