Runtime 1004 driving me insane!

Long time member, first time posting a thread.
I'm getting 1004 error: Application-defined or Object-defined error. I can't for the life of me figure out what's wrong. The debug is throwing up a line of code that is perfectly fine!? Hoping someone with a fresh pair of eyes and more know-how can shed some light?
Getting the error when I click a command button. I've only started getting the error when I added some code to the sheets change function but as far as I can tell, it should all work.

Please Login or Register  to view this content.

For reference, he's the worksheet change code:

Please Login or Register  to view this content.

Any help or suggestions would be greatly appreciated!
Thanks.

Pritch

Thanks Rory, but i've got the unprotect line again in the Worksheet change? I'm confused haha

Please Login or Register  to view this content.

Nevermind, brain fart moment. Just realised what you mean haha. Thanks Rory.

Other colleagues will be using it so it needs to be protected so they don't break it. The code unhides rows allowing them to enter data in unlocked cells based on what they select in another cell.
i.e, they select say "1" from a drop down which then unhides 1 row to allow them to enter an employee's name etc whilst the document is still protected so they can't amend any other cells.

No. But I need the Change event code to work after the button code has finished. Is there a way to do this?