I have an Microsoft Excel 2010 spreadsheet that I want to share with my team on a read-only basis; I want to prevent them from modifying it, so that I keep control of changes.
It's quite large, and I've grouped detail columns up, so that they can be easily hidden or revealed as necessary.
When I protect the spreadsheet, the grouping controls (the +/- buttons above the grouped columns) stop working; I want my team to be able to use them, so they can reveal the level of detail they want to see.
For many worksheet functions, you can unprotect them by checking a checkbox in the "Protect Sheet" dialog that appears in the protection process. There isn't a checkbox to unprotect the grouping controls.
How can I do it?