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.

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

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.

If you already have the outline/subtotals applied, you can protect the worksheet
in code (auto_open/workbook_open??).

Option Explicit
Sub auto_open()
With Worksheets("sheet1")
.Protect Password:="hi", userinterfaceonly:=True
.EnableOutlining = True
'.EnableAutoFilter = True
End With
End Sub

It needs to be reset each time you open the workbook. (excel doesn't remember
it after closing the workbook.)

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Holt88 wrote:

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.




--

Dave Peterson

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.