So what I am trying to do is make row 10 hide/unhide depending on an entry from a data validation dropdown list (Shell and Tube = unhide, all else = hide). To make things easier I have set up a True/False cell dependent on the dropdown list value and made my macros dependent on that cell.
The code shown below works fine when ran manually from VBA or in the View Macros panel. The issue I am running into is the macro will not run automatically when the proper value is selected within the dropdown list. I want the final program to run automatically and was under the impression that the way I went about writing this code would do just that. So my question is am I wrong in that assumption or have I missed a step in my process? Thanks for any help provided.
Sub Visibility()
If Worksheets("Front Panel").Range("S21").Value = "True" Then
Call Unhide
Else
Call Hide
End If
End Sub
Sub Hide()
Worksheets("Front Panel").Rows("10:10").EntireRow.Hidden = True
End Sub
Sub Unhide()
Worksheets("Front Panel").Rows("10:10").EntireRow.Hidden = False
End Sub