Lock cells without protecting sheet?

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" <RBee@discussions.microsoft.com> wrote in message
news:C29D806B-6FBD-44D1-9631-801E0D6E09D0@microsoft.com...
> 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?

You could apply protection the the sheet, after leaving some cells
unprotected, then use buttons to call a macro which unprotects /
modifies display / applies protection again.

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?

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" <RBee@discussions.microsoft.com> wrote in message
news:C29D806B-6FBD-44D1-9631-801E0D6E09D0@microsoft.com...
> 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?

You could apply protection the the sheet, after leaving some cells
unprotected, then use buttons to call a macro which unprotects /
modifies display / applies protection again.