Finding and locking formula cells
 

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

Finding and locking formula cells
 

Hi,

F5, Special, Formulas
--
Cheers,
Shane Devenshire


"Louise" wrote:

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

Finding and locking formula cells
 

Thank you.

"Louise" wrote:

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