Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using Group and Outline with Protected Cells
I am trying to protect certain cells in a worksheet that contains numerous
groupings (Group and Outline function). However in order to protect the cells, I have to protect the worksheet. When I protect the worksheet, its telling me I can not use the grouping function with a protected worksheet. Is there anyway to protect cells and still use the grouping feature? Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using Group and Outline with Protected Cells
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.) Cbruns wrote: I am trying to protect certain cells in a worksheet that contains numerous groupings (Group and Outline function). However in order to protect the cells, I have to protect the worksheet. When I protect the worksheet, its telling me I can not use the grouping function with a protected worksheet. Is there anyway to protect cells and still use the grouping feature? Thanks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Group and Outline on a Protected Sheet | Excel Discussion (Misc queries) | |||
"Data Group and Outline Group" feature Limited to 8 levels | Excel Discussion (Misc queries) | |||
Group and Outline | New Users to Excel | |||
Group and Outline | Excel Discussion (Misc queries) | |||
Group & Outline in Protected Worksheets | Excel Discussion (Misc queries) |