Forum Discussion
Using Group-Ungroup in a protected Excel sheet
what do i need t do to enable me to group and ungroup rows in my spreadsheet without having to unprotect it? Any help most welcome, thank you.
Your code works great except I wanted the user to be able to add a row. When I attempt to turn that function on within a group it would not allow if after a reopening of the workbook. Err404
Change the line
.Protect Password:="Secret", UserInterfaceOnly:=Truein the Workbook_Open event procedure to
.Protect Password:="Secret", UserInterfaceOnly:=True, AllowInsertingRows:=True