Merged cells lock after resizing

[wvvvdracovvvw]

I really hope someone can help me with the following issue.
I finally have the merged cells resizing the way I need, however it seems to lock the cell after the process not allowing it to be edited again until I unlock the sheet. below is the current code I am using

Please Login or Register  to view this content.

If anyone has ideas of what I am missing I would greatly appreciate the help.

[Leith Ross]

Hello wvvvdracovvvw,

Welcome to the Forum!

Just unlock each cell in the merged area...

Please Login or Register  to view this content.

[wvvvdracovvvw]

Not getting it to work still. Attached is the worksheet. The password to unprotect the sheet is "trial"Shift Report Trial3.xlsm

[Leith Ross]

Hello wvvvdracovvvw,

Try this out...

Please Login or Register  to view this content.

[wvvvdracovvvw]

Still did not work, but I see what you were trying to have it do. I tried moving the unlock function to the last part, and it seems to be running great.
Ended up with the following code

Please Login or Register  to view this content.

Thank you very much for the help, I know this would have taken me forever to find a solution without your help.

[Leith Ross]

Hello wvvvdracovvvw,

You're welcome. Good thinking on moving the unlock portion of the code.