One way:

To access the button:

Sheets(1).Buttons("myButton").Caption = "My Caption"

Invisible:

Sheets(1).Buttons("myButton").Visible = False

Disabled:

Sheets(1).Buttons("myButton").Enabled = False


In article ,
reddog9069
wrote:

I have a button on my worksheet created from the forms toolbar.

How do I access the button through VBA?

sheets(1).Item???

Also I would just like to make it invisible and/or disable it.
Which property would I use?

Thanks