Hiding Command Button

[SMatthews]

Is there a way to hide a Command Button?

 

[Tom Urtis]

Sure...along the lines of this if it is a command button on a UserForm:

Private Sub UserForm_Initialize()
If Range("A1").Value = "Yes" Then
CommandButton1.Visible = False
Else
CommandButton1.Visible = True
End If
End Sub


Or this if it is a command button on a worksheet:

Sub Test1()
If Range("A1").Value = "Yes" Then
ActiveSheet.CommandButton1.Visible = False
Else
ActiveSheet.CommandButton1.Visible = True
End If
End Sub

Modify for whatever it is that would trigger the Visible property. In these examples, it is the presence or absence of the value "Yes" in cell A1 of the active worksheet.