I have three radio buttons on a worksheet, and the associated subroutines are
stored in the "directory" associated with that sheet when I go to the macro
directory. Currently when I open the spreadsheet whichever button was
selected on the previous close is the one on. How can I select a button to
be on "upon open" in my auto_open routine?

I tried using a statement "Application.Run "OptionButton1_Click" in my
Auto_Open sub and it couldn't find the sub, even when it was "public". Also
tried moving the button subs to a module directory, but then EXCEL cannot
find them when the radio buttons are clicked.

The crux of this seems to be that some subroutines need to be stored in the
spreadsheets, and others are stored in modules. Guess it is obvious I don't
appreciate why there is a difference. Any enlightenment you can provide
would be appreciated.

Thanks!
Thanks!

WorkBook_Open()
OptionButton1=true

"LD" wrote:

I have three radio buttons on a worksheet, and the associated subroutines are
stored in the "directory" associated with that sheet when I go to the macro
directory. Currently when I open the spreadsheet whichever button was
selected on the previous close is the one on. How can I select a button to
be on "upon open" in my auto_open routine?

I tried using a statement "Application.Run "OptionButton1_Click" in my
Auto_Open sub and it couldn't find the sub, even when it was "public". Also
tried moving the button subs to a module directory, but then EXCEL cannot
find them when the radio buttons are clicked.

The crux of this seems to be that some subroutines need to be stored in the
spreadsheets, and others are stored in modules. Guess it is obvious I don't
appreciate why there is a difference. Any enlightenment you can provide
would be appreciated.

Thanks!
Thanks!

Scratch that i am haveing the same issue.

"Office_Novice" wrote:

WorkBook_Open()
OptionButton1=true

"LD" wrote:

I have three radio buttons on a worksheet, and the associated subroutines are
stored in the "directory" associated with that sheet when I go to the macro
directory. Currently when I open the spreadsheet whichever button was
selected on the previous close is the one on. How can I select a button to
be on "upon open" in my auto_open routine?

I tried using a statement "Application.Run "OptionButton1_Click" in my
Auto_Open sub and it couldn't find the sub, even when it was "public". Also
tried moving the button subs to a module directory, but then EXCEL cannot
find them when the radio buttons are clicked.

The crux of this seems to be that some subroutines need to be stored in the
spreadsheets, and others are stored in modules. Guess it is obvious I don't
appreciate why there is a difference. Any enlightenment you can provide
would be appreciated.

Thanks!
Thanks!

This event will run every time your workbook is opened. Replace
"OptionButton1" with the name of the Option Button you wish to have = True
when the workbook is opened.

Private Sub Workbook_Open()

OptionButton1 = True

End Sub

Ryan


"LD" wrote:

I have three radio buttons on a worksheet, and the associated subroutines are
stored in the "directory" associated with that sheet when I go to the macro
directory. Currently when I open the spreadsheet whichever button was
selected on the previous close is the one on. How can I select a button to
be on "upon open" in my auto_open routine?

I tried using a statement "Application.Run "OptionButton1_Click" in my
Auto_Open sub and it couldn't find the sub, even when it was "public". Also
tried moving the button subs to a module directory, but then EXCEL cannot
find them when the radio buttons are clicked.

The crux of this seems to be that some subroutines need to be stored in the
spreadsheets, and others are stored in modules. Guess it is obvious I don't
appreciate why there is a difference. Any enlightenment you can provide
would be appreciated.

Thanks!
Thanks!

Ok i got it this time

Private Sub Workbook_Open()
Worksheets(1).OptionButton1 = True
End Sub

you need to tell VBA where the optionbutton is.

"RyanH" wrote:

This event will run every time your workbook is opened. Replace
"OptionButton1" with the name of the Option Button you wish to have = True
when the workbook is opened.

Private Sub Workbook_Open()

OptionButton1 = True

End Sub

Ryan


"LD" wrote:

I have three radio buttons on a worksheet, and the associated subroutines are
stored in the "directory" associated with that sheet when I go to the macro
directory. Currently when I open the spreadsheet whichever button was
selected on the previous close is the one on. How can I select a button to
be on "upon open" in my auto_open routine?

I tried using a statement "Application.Run "OptionButton1_Click" in my
Auto_Open sub and it couldn't find the sub, even when it was "public". Also
tried moving the button subs to a module directory, but then EXCEL cannot
find them when the radio buttons are clicked.

The crux of this seems to be that some subroutines need to be stored in the
spreadsheets, and others are stored in modules. Guess it is obvious I don't
appreciate why there is a difference. Any enlightenment you can provide
would be appreciated.

Thanks!
Thanks!