How do I create a macro that will hide blank rows in Column-A and protected data in other

Hello,
I have an excel sheet with data and formulas from Column lines E-G.
I want to protect those columns so no one can delete or alter them.
Under column line -A is the users data entry column.
Under that column he or she will enter data based on the items they need and leave all the other items blank in that column.
I wrote macro to hide the blanks rows which works until I lock or protect the sheet.
When I lock the sheet the macro does not work I suspect because I locked the columns from E-G.
Is there a way to still lock the cells and still create a button to hide blank rows?
Do I need to write a macro to unprotect the sheet, hide the rows and then protect the sheet again?
How would that look?

https://www.automateexcel.com/vba/un...ct-worksheets/

Maybe read the above article as there can be more to it then just unprotecting and protecting. It all depends on.
Just unprotecting, doing your stuff and then protecting again is simple enough as you will see.