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.
