I need a formula when the worksheet come up just three question shows. but
when the last question is asked and it is a true statement I would like
excell to show the rest of the rows but if the question is no then excell
keeps the rows hidden. For example

If Question 1 is Yes(True)- Keep rows 16 through 84 hidden
IF Question 2 is Yes(True) keep rows 16 through 84 hidden
If Question 3 is Yes(True) Undie rows 16 through 84.

Am I wishing on a pipe dream?