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.
I have attached a very simple demo workbook. Does it work for you if you allow macros when you open it?
Hi Hans, yes it does, i already have macros enabled, it works great, i will recheck my sheet to ensure i have not got some cells locked or something, i don't think i have but whatever it is the problem must be at my end. i will let you know and thank you once again for your help.