Code not working (hide rows) - two change worksheet codes in one

Hello,

so first of all - I'm fairly new to the world of VBA but I do think it's amazing. :-)

So i do have a form which needs to be filled out by our customers. And i do have a Worksheet_Change Code so that you're able to choose more than one option from a dropdown list which is working perfectly fine. What I would like to do now is to add another code - There's one dropdown (cell D43) with two options "Yes" and "No". If "No" is chosen rows 45 - 52 needs to be hidden, if "Yes" is chosen the rows should be visible. I know how to set up the code in general but i am not able to add it to my existing code so that it is working. Do you have any idea how to do that?

The existing code looks like that:

Please Login or Register  to view this content.

Thanks so much.
Nadine

file attached -sorry!

So I actually was able to get the macro / code running - both are running - as long as the worksheet is unprotected but as soon as I would like to protect the sheet i receive an error message when trying to change anything in the related cells

"Run time error 1004
unable to set the hidden property of the range class

Attachment 832895

any ideas on this one? :-(