How can I use open/close Grouped cells in a Protected Worksheet?
 

Can anyone help me please - When I include Grouped cells in a Worksheet
by using "Data" / "Group and Outline", excell will not allow opening or
closing of the Grouped cells when the Worksheet is protected. Is there
an easy way I can open/close Grouped cells in a Protected Worksheet?


--
Andy Bowshell
------------------------------------------------------------------------
Andy Bowshell's Profile: http://www.excelforum.com/member.php...o&userid=30469
View this thread: http://www.excelforum.com/showthread...hreadid=501330

How can I use open/close Grouped cells in a Protected Worksheet?
 

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

Andy Bowshell wrote:

Can anyone help me please - When I include Grouped cells in a Worksheet
by using "Data" / "Group and Outline", excell will not allow opening or
closing of the Grouped cells when the Worksheet is protected. Is there
an easy way I can open/close Grouped cells in a Protected Worksheet?

--
Andy Bowshell
------------------------------------------------------------------------
Andy Bowshell's Profile: http://www.excelforum.com/member.php...o&userid=30469
View this thread: http://www.excelforum.com/showthread...hreadid=501330

--

Dave Peterson

How can I use open/close Grouped cells in a Protected Worksheet?
 

Thanks Dave - I'll try what you say and Yes I'm not too well up on
Macros so I'll look at the reference you've suggested.

Thanks Again


--
Andy Bowshell
------------------------------------------------------------------------
Andy Bowshell's Profile: http://www.excelforum.com/member.php...o&userid=30469
View this thread: http://www.excelforum.com/showthread...hreadid=501330