text: Q:
  
  How to hide sections of an excel page depending on drop down list selection
  
  I currently have a questionnaire sheet in an excel document that is separated into "Part One" and "Part Two". Within these two sections, there are additional questions. "Part One" has 4 questions and "Part Two" has three.
  Both "Part One" and "Part Two" are displayed on the same Sheet.
  Before beginning "Part One", I have added a Drop Down List that the user can select if they have completed the questionnaire before.
  If they select "I have" from the drop down list, then I only want "Part One" of the page to display and "Part Two" to be hidden.
  If the user selects "I haven't", then I would like both "Part One" and "Part Two" to display.
  How would I approach completing this task?
  I have a very basic knowledge of excel so sorry in advance for any obvious questions.
  Any support would be much appreciated. 
  
  A:
  
  If I was forced (!) to accomplish this task on a sheet inside Excel I would probably have looked at @TheEngineer's link in comments section above.
  Here is another thread with a similar discussion
  The key functions would probably have been:
  Range("XX:YY").EntireRow.Hidden = [True | False]
  Range("ZZ:WW").EntireColumn.Hidden = [True | False]
  
  