Enabling hide/unhide rows in protected sheet

**gm2612** · 05-14-2014, 05:56 AM

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

**TMS** · 05-14-2014, 06:14 AM

When you protect the sheet, tick the option to allow you to Format Rows

Regards, TMS

**gm2612** · 05-15-2014, 03:46 AM

Hello TMS, thanks for the reply, but I tried this before posting the question, and found not working. I am using Excel 2003. Can you please tell me some other method if available?

Thanks again.

Regards,
gm2612

**TMS** · 05-15-2014, 05:16 AM

No, not really, it's the only way I know.

See the attached example. Does this work for you? You should be able to change cells from A2 to F20 by selecting from a drop down box. You can hide rows. You can delete values in that range as the cells are unlocked.

Regards, TMS