Group/Ungroup with sheet protected

H

Holt88

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

Doug Kanter

Holt88 said:
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.
 
H

Holt88

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

Dave Peterson

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
 
D

Doug Kanter

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top