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