Openning Grouped Columns in Protected Sheets

  • Thread starter Thread starter Hande & Tolga
  • Start date Start date
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.
 
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

Protect Sheet 1
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
Excel Protection 2
hide columns on a protected sheet??? 1
Protected Sheet and grouping 1
Protect a sheet but allow columns to unhide 1
Excel Data Protection Best Practice: AKA: Real Sheet Protection 4

Back
Top