"Holt88" wrote in message
...
I have a sheet where I expand and collapse using the group/ungroup buttons
on
the left of the sheet(+/-). However, when the sheet is protected, this
functionality is not allowed. Is it possible to have a protected sheet but
still use the Group/Ungroup functionality? Thanks in advance.

Is it protected to keep others from screwing it up, but you want it
UNprotected when YOU use it? If so, create a small macro for turning
protection off & on, and connect it to a couple of custom buttons on your
tool bar.