RBee,

You could use the worksheetchange event to try to protect those cells from changes. However, if the
workbook is opened with macros disabled, then you are out of luck.

HTH,
Bernie
MS Excel MVP


"RBee" wrote in message
...
Is there a way to lock (or something like it) cells in a sheet without
protecting the whole sheet? I've got some cells that need to locked from
users changing the formulae, but cannot protect the sheet because I'm also
using the outlining feature (grouping) to expand and collapse rows.

I guess an alternative question would be....is there a way to use the
outlining feature in a protected sheet?