Openning Grouped Columns in Protected Sheets

H

Hande & Tolga

We want to put such a protection to the sheet that, the
protection will not prevent the user from openning
grouped columns.
 
J

Jim Rech

This is possible only through a macro, for example:

Sub a()
With Sheet1
.EnableOutlining = True
.Protect , True, True, True, True
End With
End Sub

This setting does not get saved with the workbook, so it must be reset by
running this macro each time the workbook is opened.
 
Top