Worksheet Protection

[istephens]

I use grouping of rows and columns extensively for showing monthly
quarterly, annually etc fiqures so that users may view summary o
detailed information by the + & - grouping selections.

I have found that when I protect the worksheet - I am unable to use th
+ & - grouping functions to view the detail.

I would be very grateful if someone could assist me with where to fin
the protection setting that will allow this.

Many thanks
Ian
:confused

 

[janmike]

Add this routine. I had the same problem & received this tip from thi
site. Works great.


Sub Macro1()
Option Explicit
Sub auto_open()
With Worksheets("worksheet name")
.Protect Password:="your password", userinterfaceonly:=True
.EnableOutlining = True
End With
End Su

 

[istephens]

Thank you for this advice which worked fantastically and has solved my
problem.

Regards
Ian