software

Can anyone help me please - When I include Grouped cells in a Worksheet
by using quot;Dataquot; / quot;Group and Outlinequot;, 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: www.excelforum.com/member.php...oamp;userid=30469
View this thread: www.excelforum.com/showthread...hreadid=501330If 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(quot;sheet1quot;)
.Protect Password:=quot;hiquot;, 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:
www.mvps.org/dmcritchie/excel/getstarted.htm

Andy Bowshell wrote:
gt;
gt; Can anyone help me please - When I include Grouped cells in a Worksheet
gt; by using quot;Dataquot; / quot;Group and Outlinequot;, excell will not allow opening or
gt; closing of the Grouped cells when the Worksheet is protected. Is there
gt; an easy way I can open/close Grouped cells in a Protected Worksheet?
gt;
gt; --
gt; Andy Bowshell
gt; ------------------------------------------------------------------------
gt; Andy Bowshell's Profile: www.excelforum.com/member.php...oamp;userid=30469
gt; View this thread: www.excelforum.com/showthread...hreadid=501330

--

Dave Peterson


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: www.excelforum.com/member.php...oamp;userid=30469
View this thread: www.excelforum.com/showthread...hreadid=501330