I have 2 worksheets - both have a row of questions. Sheet 1: Pre-Questionnaire, Sheet 2: Detailed Questionnaire (Sheet 2 starts off hidden)
- Sheet 1 has a row of 11 questions.
- I want the first two questions on that to show upon opening the questionnaire.
- The second question has a Yes, No option, If Yes selected, I want the other 9 questions (rows to be made visible) AND Sheet 2 to also be now visible
- Question 11 has a list of answers, if answer "C" is selected, I want questions (rows) in Sheet 2 from 69-80 to be unhidden.
I have the code working for the last part - but I am struggling to get the other two evaluations to work. Code for part 2 I am using is this: