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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

protecting formulas without protecting sheet so grouping still wor 1
I can't able to protect a sheet if it having any column / rows gro 4
hide columns on a protected sheet??? 1
Protect a sheet but allow columns to unhide 1
Protect Sheet 1
Protected Sheet and grouping 1
Block cracking code from opening protected excel sheets 5
Excel Data Protection Best Practice: AKA: Real Sheet Protection 4

Top