assign hyperlink to radio button

[bumstead]

hello all
Does anyone know -- is it possible to assign a hyperlink to a radio button? I have 6 radio buttons. I would like the user to click on a radio button (which I have linked to some formulas). The same click should also take them to one of 6 corresponding worksheets.

First preference is to do this without VBA. If this is not possible, then VBA is a fine choice.

Thanks so much

 

[Nebu]

Hi:

I guess you need VBA for this upload a sample file.

Thanks