Run-time error 1004: Unable to set the Hidden property of the Range class

Hello friends,
I hope someone can help me solve the above problem.
I've an macro that hide and unhide rows.
I want it to be able to hide the row with an empty cell.
I also want it to be able to unhide the row if I want to fill in the empty cell.
I've the worksheet protected to prevent accidental changes to the formula cells.
However, when the worksheet is protected, the macro cannot work and displayed the above message.
When it is unprotected, the macro works.
I've attached an example of the worksheet.

Thank you.
KS Chan

Unprotect the sheet when the sub runs and reprotect it again at the end.

Please Login or Register  to view this content.

BSB

Thank you very much.
It is working properly now.

KS Chan

No problem. Happy to help

BSB

Be wary, UserInterfaceOnly is not 100% reliable and some performing some actions using code whilst sheets have this property set to True will still throw up errors.

BSB