View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rob Rob is offline
external usenet poster
 
Posts: 718
Default Hiding/Showing Rows on Cell H2 Change

Hello.

What I have is a spreadsheet and when you open the workbook Cell H2 is empty
and the user selects either "System" or "Detail" from a dropdown list that's
in H2. What I want to do is to hide rows 32 & 33 if H2 is = "Detail" But if
it is "System" it doesn't hide them. However, and here's a tricky thing, if
the user selects "System" after they already selected "Detail" I need rows 32
& 33 to unhide.

Is this possible somehow and if so How would I do it?

Thanks Much In Advance.
Rob