Hide a row based on a drop down menu selection

**AMechEng** · 06-19-2012, 12:14 PM

Hi,

I am trying to get a single row; row 20, to either hide or unhide depending on what is selected from a drop down menu. The drop down menu is located in a merged cell; P10:R10. The drop down menu only has two options; "Horizontal" or "Vertical". I want to get row 20 to hide when "Horizontal" is selected and then to unhide when "Vertical" is selected.

I have been trying all day with various macros and formulas out there but with no luck . My knowledge of VB is basic.

Thanks

**Palmetto** · 06-19-2012, 12:44 PM

Please Login or Register  to view this content.

Code goes into the worksheet module.

**AMechEng** · 06-19-2012, 01:30 PM

Thank you for getting back to me, however, I have entered that as a new module but nothing happens. I have tried restarting the spread sheet and re-doing the module again but no luck.

**Palmetto** · 06-19-2012, 04:54 PM

The code must go into the worksheet module -- *NOT* a standard module.
Right-click the worksheet tab > view Code > Paste the code in.

You must save the workbook as a macro-enabled (.xlsm) type and enable the macros when prompted upon opening the workbook.