Forum Discussion
Grouped columns on protected sheet
Hi All. Experiencing a strange issue with one of my workbooks and I’m hoping someone may be able to shed some light. I have a sheet which has grouped columns and the sheet is protected. Under sheet...
Hi sarahstewart, did you manage to solve this issue? I have the same problems, got a sheet with grouping for which I would like to grey out AZ and number sorting, but leave filtering possible. Once I set these last two options with protect sheet, grouping is also disable and I cannot use the + or - signs.
Thank you for any input.
Thank you for any input.
- Hello,
Your problem sounds a little different than mine- my issue was that the protect options were working fine for some people using the spreadsheet, but not for others.
In the end I had to use a macro that allows protected sheets to be grouped and in grouped. This way, all users were able to use the grouping function with no issues. It was just annoying as it shouldn’t have been required- the protect options should have worked for all users. Never got to the bottom of why it didn’t.
Here’s a link to the VBA code for the whole workbook which I used:
https://www.thespreadsheetguru.com/the-code-vault/groups-expand-collapse-sheet-password-protection
Good luck!
