Hi and Welcome to the Board,
"Button 1" is probably a Form Control. If you use an ActiveX control you might find it easier to control its properties.
You can insert an ActiveX button from the same Toolbox you used to insert your Form Button.
Here is some code that will work with an ActiveX button...
Code:Private Sub Worksheet_Change(ByVal Target As Range) 'If Cell value = "Yes" Show Button Dim sAddress As String sAddress = "$D$26" With ActiveSheet If Intersect(Target, Range(sAddress)) _ Is Nothing Then Exit Sub Debug.Print Range(sAddress).Value On Error GoTo CleanUp Application.EnableEvents = False Me.CommandButton1.Visible = _ (Range(sAddress).Value = "Yes") End With CleanUp: Application.EnableEvents = True End Sub