So normally when you insert a row into grouped rows, it will expand the grouped rows by 1 to keep the grouping. However I have a protected workbook and worksheet.

In my vba code, I Unprotect the workbook and the worksheet and then insert the code, but the grouping doesn't adjust. Is there something I have to do to make it adjust. I enabled outlining as well. Here is my code

Please Login or Register  to view this content.