Sounds like something that could be done with VB, but it's outside my limit
of knowledge.


"Holt88" wrote in message
...
I want it protected when others are in the so they don't screw cell
content,
but still want users to have the Group/Ungroup functionality. I could
create
a few buttons to hide/unhide rows but my users liked the +/- option.

"Doug Kanter" wrote:


"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.