Hide/Unhide Rows in a protected sheet using a checkbox

[kares]

This is just my trial sheet. It is where I practice the code I will be using in my project.

The scenario here is that when I tick the checkbox, I want to hide/unhide Rows 2:3 while the sheet is also protected.

Its main purpose is to let users know where to input the needed data depending on its category.

This is the flow of my project:
If B1=True
Then Rows 2:3 will be shown while the sheet is protected, letting users know that they have to input data into the specific cell in those rows

But, if B1=False
Then Rows 2:3 should be kept hidden while the sheet is protected

The code I am using now applies only when the sheet is UNPROTECTED. It would be nice if the code could be used whether the sheet is PROTECTED OR NOT.

Hope someone can help me with this one.

Thank you.

 

[Fluff]

Duplicate to: Unprotect specific cells only when a hidden row was shown by clicking the checkbox

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.