Solved: Activate Macro When Sheet is Opened?

[doctortt]

Hi,

How do you make Excel to activate this IF statement when the VBA program is started?

If OptionButton1.Value = True Then
Showmethis 'this is the macro for launching something
End if

So whenever Excel detects the TRUE for this optionbutton1, it will launch "showmethis" which is the macro.

[Bob Phillips]

[VBA]Private Sub Workbook_Open()
If OptionButton1.Value = True Then
Showmethis 'this is the macro for launching something
End if
End Sub[/VBA]

This is workbook event code.
To input this code, right click on the Excel icon on the worksheet
(or next to the File menu if you maximise your workbooks),
select View Code from the menu, and paste the code

[doctortt]

[vba]Private Sub Workbook_Open()
If OptionButton1.Value = True Then
Showmethis 'this is the macro for launching something
End if
End Sub[/vba]

This is workbook event code.
To input this code, right click on the Excel icon on the worksheet
(or next to the File menu if you maximise your workbooks),
select View Code from the menu, and paste the code

HI, I did paste the code then saved the excel file. However, when I open the excel file, "showmethis" doesn't launch. =(

Why?

[Aussiebear]

Did you paste the code into the ThisWorkbook module?

[doctortt]

Did you paste the code into the ThisWorkbook module?

I right clicked the worksheet and selected view codes. That brought me to the editior and I pasted the codes there.

[Aussiebear]

Your code needs to reside in the ThisWorkbok module. Please check which module you have placed the code into.

[doctortt]

Your code needs to reside in the ThisWorkbok module. Please check which module you have placed the code into.

Ohh!! I found 'ThisWorkbook' module, and it's working the way that I want now.

Thank you so much