title: Showing and hiding Objects
body: <p>I was hopping someone could guide me into the right direction here. I have a 3 objects that I want to disappear when the "White" is selected from the dropdown otherwise to stay visible.  So far I got this:</p>
  
  <pre><code> Dim Wc As Worksheet
      Set Wc = Sheets("Sheet1")
      Dim MyArray(1 To 3) As Range
      Dim SCC As String
  
      Set MyArray(1) = Sheets("Sheet1").Range("Object01")
      Set MyArray(2) = Sheets("Sheet1").Range("Object02")
      Set MyArray(3) = Sheets("Sheet1").Range("Object03")
  
      SCC = MyArray
  
      If Worksheets("Sheet1").Range("MyRange").Value = "White" Then
          ws.Shapes(SCC).Visible = False
      Else
          ws.Shapes(SCC).Visible = True
      End If
  </code></pre>
  
  <p>Any ideas why it's not working? Any suggestions more then welcome  </p>