Grouping on Protected sheets

[hellomynameiskristin]

I have a workbook with about 11 sheets. Its a pretty complex workbook and I am only allowing certain ranges to be editable. I also have alot of Groups that can be expanded or collapsed, but that doesn't work.

I want to protect the sheet against changes, but I also want to let users expand or collapse the groups. Is there a way to do that?

 

[GlennUK]

Hi Kristin,

I usually have embedded buttons in my sheet to do that ( when a sheet is protected ). You unprotect the sheet, do the action, and reprotect the sheet, inside your button code.

 

[ColinKJ]

Hi Kristin,

If before you set the sheet protection, select the cells which are allowed to be edited, goto Format>Cells, select the Protection Tab, and Un-Check the Locked Option.

Then, when you protect the sheets, only the editable cells are accessable.

 

[RoryA]

You need to protect the sheets using the UserInterfaceOnly:=True argument and set the sheet's EnableOutlining property to true. This needs to be set every time the workbook is opened.