Excel Worksheet Protection & Grouping

[krizma5683]

Is there a way to protect a user from modifying fields in your spreadsheet, while still allowing the user to use the group/ungroup feature in Excel?
When I set the worksheet protection on it won't let the user collapse/uncollapse the +/- button for the grouping feature.

 

[GlennUK]

No, I don't think so. When my users need to do this I have to write macros and embed buttons in the workbook to collapse/uncollapse the groupings.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.