title: VBA excel not run unless i click play button
body: <p>I don't know where i have gone wrong. The Script works but it doesn't automatically run unless i go into the VBA application and click the play button for the script to run. Can someone help?</p>
  
  <pre><code>Private Sub HideChart1()
  
      If ActiveWorkbook.Sheets("User Interface").Range("F8") = "Yes" Then
  
          ActiveWorkbook.Sheets("Sheet1").ChartObjects("Chart 6").Visible = True
  
      Else
  
          ActiveWorkbook.Sheets("Sheet1").ChartObjects("Chart 6").Visible = False
  
      End If
  
  End Sub
  </code></pre>