I have four check boxes that each respond to code when checked. Different fields are displayed in a pivot chart. I want to display a chart when check box 4 is TRUE and hide the chart when any of the other check boxes are true. The code I am using is not working correctly?
Dim ChtObj As ChartObject
Set ChtObj = ActiveSheet.ChartObjects(1)
If Range("Trigger12") = True Then
ChtObj.Visible = False
If Range("Trigger3") = True Then
ChtObj.Visible = False
If Range("Trigger2") = True Then
ChtObj.Visible = False
Else
ChtObj.Visible = True
End If
End If
End If
Thanks in advance
Bookmarks