Tsudoi has attended:
Excel PowerPivot course
Excel VBA Introduction course
Group/Ungroup on protected sheet
Hi,
I have an Excel workbook with one of the sheets having certain areas password-protected but I want to allow group & ungroup rows and columns. It's only one sheet that has such a protection but if VBA code will do the trick, please advise the coding?
Thanks!
RE: Group/Ungroup on protected sheet
Hi Tsudoi
Please check out the below website for advice on how to enable group/ungrouping
https://www.thespreadsheetguru.com/the-code-vault/groups-expand-collapse-sheet-password-protection
Regards
Dennis