How do I run the macro for a button click without clicking the button?

I have an embedded button and code that runswhen it is clicked.
It is:
Public Sub Show_Hide_Button_Click()
I want to run that code when the workbook opens.
So in the Workbook_Open() routine i have a line:
Show_Hide_Button_Click
But the compiler says the Sub or Function is not defined.

Alternatively, I wild like to change the label on the button, but do not know how to reference it.
Using this inside the Workbook_Open routine does not work
Show_Hide_Button.Caption = "Show Sheets"
It says the variable Show_Hide_Button is not defined.
Suggestions?
thanks

I figured this out, by referencing the caption as Sheets("Charts").Show_Hide_Button.Caption it worked.

For the on open event try

Please Login or Register  to view this content.

That works too, thank you.

No problem! Don't forget to mark this thread solved and maybe give a star tap if I helped.
Thanks!