Hi Folks,
I have a macro that I'm using to hide rows based on content of another cell. It's this:
I want to protect the rows that are being hidden/unhidden and only allow certain cells within the row to be changed.Please Login or Register to view this content.
Basically, if row 25 remains unhidden, I only want someone to be able to change J25, for instance.
When I try to protect the worksheet, however, the macro can't run to hide the rows. Is there a workaround for this or do I just need to keep the entire row unprotected?
Bookmarks