Merged Cell protection
Hello, I am having an issue with merged cell protection, it may already be known, I have seen a few posts floating around with similarish issues.
I have a protected sheet with merged cells that are unlocked. I removed the protection on the sheet to edit a few other cells, then when I re-protected the sheet, the merged cells that were unlocked in excel are now locked.
I'm not sure if its because the merged cell range A7:B7 A7 is specified as unlocked and unhidden but B7 is locked so it takes the locked precedent. if I manually specify Protected(locked=False) for every cell in the range the merged cell covers, it will stay unlocked.
kinda weird