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.
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.
