option buttons

[janet]

is there anyway of assigning a macro to an option button?

depending on the option button selected, I want different
worksheet to become active

 

[Mike Hughes]

Janet,


Place your buttons on a worksheet and right click each and assign the
following code

Sub OptionButton2_Click()
Worksheets("sheet2").Select
End Sub

attach the code to each button and change the name of the sheet you want to
be active for each button

Mike