Protected Sheet, lost functionality (collapse, expand)

[andrea91]

I’m trying to protect cells in my worksheet while maintaining the functionality of collapsing and expanding the worksheet. I’m working in Microsoft Excel 2013.
I’ve read that I need to run the following code:

Private Sub Workbook_Open()

Sheets("Sheet1").Protect Password:="", UserInterfaceOnly:=True
Sheets("Sheet1").EnableOutlining = True

End Sub
Where do I insert the code? I want to be able to have this functionality after I save, close and reopen the workbook. I don’t want to have to run the code every time. Any advice is helpful! New to this. Thank you.

 

[jproffer]

while maintaining the functionality of collapsing and expanding the worksheet

What is expanding and collapsing the worksheet mean?

If that code will do what you want (and I don't think it will), it would go in the workbook module.

Open the workbook. Alt+F11 (open VBA)...Ctrl+R (Project Explorer)...expand the dropdown by your workbook name...find "ThisWorkbook" in the "Microsoft Excel Objects" folder and double click....paste code in the white area to the right.

 

[andrea91]

The + / - button that allows you to hide or unhide cells. Unsure of what is it called but you are correct, the code did not work. -__-

 

[RoryA]

That code should work. It must be in the ThisWorkbook module of the workbook. Once it is there, save, close and reopen the workbook.