How do I protect a sheet that has a group/outline in it

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

so that the group can still be expanded and retracted once the sheet is
protected?
 
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.)
 
You must log in or register to reply here.

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

Group and Outline on a Protected Sheet 14
Protect worksheet but expand and collapse outline? 1
Sheet protection and "Group and Outline" 8
Enable outlining in a protected worksheet 8
Odd behavior from Protected Sheet 1
Grouping/Outlining in Excel 2003 with Protection turned on 1
How do I remove the outline protection in Excel sheet? 1
How to use outline data (grouped rows) in a protected worksheet? 1

Back
Top