View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Louise Louise is offline
external usenet poster
 
Posts: 217
Default 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