Excel outline and protection

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

Guest

How can I protect the formulars in my Excel sheet when the sheet is outlined and I want to keep the functionality of the outline? If I protect the sheet, I can not open or close a level in the outline.
 
You can only enable outlines and have worksheet protection through a macro:

With Worksheets("Sheet1")
.EnableOutlining = True
.Protect UserInterfaceOnly:=True
End With

The EnableOutlining property (and UserInterfaceOnly) is not saved with the
workbook unfortunately, so this code would have to be run each time the
workbook is open.
 
Back
Top