Below code sometimes works, sometimes not, why? Could you please comment ?
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
column = Target.Column: row = Target.Row
If column = 1 And row = 1 Then
ActiveSheet.Shapes.Range(Array("Button 2")).Visible = False
Else
ActiveSheet.Shapes.Range(Array("Button 2")).Visible = True
ActiveSheet.ComboBox2.Visible = False
End If
.
.
.
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
column = Target.Column: row = Target.Row
If column = 1 And row = 1 Then
ActiveSheet.Shapes.Range(Array("Button 2")).Visible = False
Else
ActiveSheet.Shapes.Range(Array("Button 2")).Visible = True
ActiveSheet.ComboBox2.Visible = False
End If
.
.
.
End Sub