software

How can I open or close grouped columns/rows in a protected excel sheet ?


Try copying the sheet (or columns) into a new workbook.--
mdbct
------------------------------------------------------------------------
mdbct's Profile: www.excelforum.com/member.php...oamp;userid=28733
View this thread: www.excelforum.com/showthread...hreadid=494412Unprotect the sheet.

An alternative is to protect the sheet in code and give it a special instruction
that allows either autofiltering or outlining to work on a protected sheet.

If you already have the outline 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

Haranath wrote:
gt;
gt; How can I open or close grouped columns/rows in a protected excel sheet ?

--

Dave Peterson