How 2 do expand/collapse Groupped Columns after worksheet protecti
If you already have the outline/subtotals/autofilter 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
'If .FilterMode Then
' .ShowAllData
'End If
End With
End Sub
It needs to be reset each time you open the workbook. (Earlier versions of
excel don't remember it after closing the workbook. IIRC, xl2002+ will remember
the allow autofilter setting under tools|Protection|protect sheet, but that
won't help when you're filtering via code.)
ToMMie wrote:
For example,
I've groupped Column A - F. Then, I protect the worksheet.
After the protection of worksheet, I just can't expand or collapse the group
of those columns.
So, could you help me out for this?
Many thanks.
ToMMie
--
Dave Peterson
|