Dear Experts, I have been supported by you many times in this forum for various macro requirements, and I am thankful to you all. This time I am with a similar request.

I have a simple worksheet, which is protected to maintain the drop down list intact in rows 3:150. In these rows, many of them may be empty. I would like to activate hide / unhide rows option, inspite of the sheet protected. Can you please help me out?

Many thanks for the support.

gm2612