I'm using MS Office Excel 2003.

I have a spreadsheet with a series of cells that require an input of (Y)es,
(N)o or (H)ide. If the user enters an "H" for hide I want that entire row to
Hide. Is there a Macro I can use to make this happen.

Also, I would need a switch at the top of the spreadsheet that would allow a
user to enter a "U" for "Unhide" so that all hidden rows could be "U"nhidden
and visable again. Is there a Macro I can use to make this happen also ?

Thank You for your help.