VBA help

[John5]

I have a 3 work sheet workbook
Sheet2 is Dropdown
Sheet3 is Questions
Sheet6 is Switch config

Im using this to create config for a network device by answering question on the questions sheet. I am building it so going to the other sheets wont be needed. The issue I have is I need to run Switch config macros when a change event happens on Questions. The Macros are used hide cells that are not needed based on questions. This part works but I have to go to that sheet to make a change for the macros to run. This is of course not what I want. I would prefer it to be auto so a change on Questions sheet runs macros on Switch config.

The other option is to start Switch config macros after Questions macro ends. Either way it runs the Switch config macros based on change event on Questions sheet.

 

[John5]

Found the resolution. I moved all Macro's over to the Question sheet that runs it every time something is changed and just pointed the commands to the other sheets. Using a helper formula to achieve my intended results.

Example

Worksheets("Switch config").Rows("44:49").Hidden = (Worksheets("Dropdown").Range("A10").Value = "No")