Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to use outline data (grouped rows) in a protected worksheet?
When protecting a worksheet containing outline data (grouped rows), the
expand/collaps buttons in the margin get unaccessible. Is using outline data in protected sheets really impossible? |
#2
|
|||
|
|||
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("sheet1") .Protect Password:="hi", userinterfaceonly:=True .EnableOutlining = 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.) biometris wrote: When protecting a worksheet containing outline data (grouped rows), the expand/collaps buttons in the margin get unaccessible. Is using outline data in protected sheets really impossible? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use outline data (grouped rows) in a protected worksheet? | Excel Discussion (Misc queries) | |||
Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
Multiple rows of data on a single axis (charting) | Charts and Charting in Excel | |||
Why can't I show or hide rows in an outline on a protected sheet? | Excel Discussion (Misc queries) | |||
how do i merge 2 rows of data into one | Excel Discussion (Misc queries) |