Using groups in protected sheets VBA

[Rebro88]

Hi guys,

I need a VBA to enable the use of expanding / collapsing groups in protected work sheets.

Not all work sheets have groups or protection, I'm not sure if that makes any difference.

I have tried a few codes from google searches some required a password when the workbook opened which isn't suitable for what I'm doing.
Some worked but when I closed and re opened they no longer worked.

Can someone help?

Thanks

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...ng-groups-protected-workbook.html#post5079190

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.