How to allow outlining / grouping in protected worksheet?

[DeletedAccount918]

Hey,

we are currently working on a excel form where is many levels.
I need to set protection to this sheet, but in the same time allow the users to use outlining and grouping of the levels (+ a - signs on the left). I can not find such a option in the protection window...

Thanks in advance for your help!
T.

 

[Jaafar Tribak]

Hey,

we are currently working on a excel form where is many levels.
I need to set protection to this sheet, but in the same time allow the users to use outlining and grouping of the levels (+ a - signs on the left). I can not find such a option in the protection window...

Thanks in advance for your help!
T.

I believe you can only do that via some continuous loop running in the background or via subclassing both of which can have a impact on performance plus the user will have to have the macros enabled .

If you are still interested I can post some code sample for you.

Regards.

 

[DeletedAccount918]

OK, so finally we decided to leave it unprotected.. but thanks anyway.
Have a nice weekend!