Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Grouping
Very simple question, but one I cannot manage to answer.....
Using XL2003, is it possible to protect a worksheet, but still have the grouping buttons work? Is this possible using XL2007? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Grouping
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.) I've never tested it in xl2007. Paul W Smith wrote: Very simple question, but one I cannot manage to answer..... Using XL2003, is it possible to protect a worksheet, but still have the grouping buttons work? Is this possible using XL2007? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
To sum by grouping | Excel Discussion (Misc queries) | |||
grouping | Excel Discussion (Misc queries) | |||
Grouping | Excel Discussion (Misc queries) | |||
Row Grouping | Excel Programming | |||
Grouping | Excel Worksheet Functions |