View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Matt Beardsley Matt Beardsley is offline
external usenet poster
 
Posts: 5
Default Protect cell range

I am trying to password protect a set of formulas so that users cannot change
them. For some reason I cannot get this to work with this specific file but
can with others (following steps from Excel Help works with other files but
not this one).

The sheet will not let me change any cell regardless of the range I choose.
If I choose a cell within my protected range it will ask for the
range-specific password, otherwise it tells me the sheet is protected (needs
the sheet-specific password).

What am I missing? Would using CSEs or macros matter?

Thanks in advance,

MB