Excel 2007: How to allow expanding/collapsing of grouped columns/rows when the sheet is protected?
Hi, I group a few columns together in a worksheet. I can expand the columns by clicking on "+" button and collapse them again with the "-" button. However, this is not allow when I protect the sheet. I want to be able to expand and collapse while protecting some cells in the worksheet.
It is not possible to allow grouping / ungrouping of cells when the sheet is protected. You can achieve this only by leaving the sheet unprotected or by handling the whole thing through VBA Code.
pkhari: oh, you wrote that it is possible through VBA code. I didn't notice this. My apologies!
So, please, consider my previous comment as just a link to the VBA code.
Regards,
Hlina
0
cemathwigCommented:
Regarding Excel 2007: How to allow expanding/collapsing of grouped columns/rows when the sheet is protected?
A question/solution (highly rated) was posted:
Hi, I group a few columns together in a worksheet. I can expand the columns by clicking on "+" button and collapse them again with the "-" button. However, this is not allow when I protect the sheet. I want to be able to expand and collapse while protecting some cells in the worksheet.
I want to do similar, but with rows. The VBA solution (and others similar that I have tried) do not work. No amount of VBA appears to work, even with macros enabled. I'm not sure what I'm doing wrong. Any other solutions??
0
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
It is not possible to allow grouping / ungrouping of cells when the sheet is protected. You can achieve this only by leaving the sheet unprotected or by handling the whole thing through VBA Code.
Cheers
P.K.