Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How 2 do expand/collapse Groupped Columns after worksheet protecti
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect worksheet but expand and collapse outline? | Excel Discussion (Misc queries) | |||
How do I move the expand/collapse for rows and columns in Excel? | Excel Worksheet Functions | |||
Expand and Collapse Columns | New Users to Excel | |||
How do I create columns that expand and collapse in Excel? | Excel Worksheet Functions | |||
format columns to collapse and expand in excel | Excel Discussion (Misc queries) |