Hide drop downs

[Alwyn]

Hi
I have drop down lists on an Excel spreadsheet. I want to hide the rows they
are on, but when selecting hide rows, all the rows will hide but one of the
drop downs will remain on the sheet. It tends to be the last dropdown or
selection control on the rows being hiden. They do not have focus at the time
of hiding, but still stay visible.

Any help would be appreciated.

Regards
Alwyn