Hi,

On my excel sheet I have a button named Button14. I want to control if the button is enabled by comparing the contents of values in cells C25 and E25.

I have created another button named button50. In the click property of this button, I have written the following code:

Sub Button50_Click()

If [C25].Value = [E25].Value Then
Button14.Visible = True
Else
Button14.Visible = False
End If

End Sub

In excelsheet, when I click on Button50, it gives me an error "Runtime error 424" - object required. In debug mode, the highlighter in on the line
" Button14.Visible = True" from the above code.

Can someone help me in identifying what is it that I am doing wrong?

Thanks in advance.

Warm regards,
--Prasad

ps: Is there any way I can find out the "name" of the commnad button which I have already created and then renamed its text later?