Excel vba

Hi Carole,

Thank you for your question.

The problem with code is accessing the command button using the Activesheet command.

What I suggest is you select the sheet you are working with as the first line of code(be explicit with the sheet you are working with).

Once the sheet has been explicitly selected then you can use the command cmdButton.visible = true.

Please find the code below and replace the sheet name and button name:

Sheets("Test Sheet").select

If Range("E63") = "Yes" Then

Rows("37:40").EntireRow.Hidden = False

cmdTest.Visible = True

Else

Rows("37:40").EntireRow.Hidden = True

cmdTest.Visible = False

End If

I hope this answers your question.

Regards

Simon