Control Toolbox , user paths

Originally Posted by penzer

cheers for your help. how would i go about getting a hyperlink to load if the user was to select/click a button (not just a macro ) i mean the button in the control toolbox (radio button it might be called) the singular button

thanks

Hi,

You'll need to write a one line piece of code (or macro) and attach it to the button. Personally I'd use the square button from the Forms toolbar rather than the radio button which is usually used within a frame for selecting one of several options. Don't forget you can attach macro code to any object. It doesn't have to be a forms control object. It could be an icon, or even a picture graphic taken from the hyperlink site you want to get to.

Anyway, whichever you use, here's the code:

Sub MyHyperlink()
    ActiveWorkbook.FollowHyperlink Address:="http://www.excelforum.com/newreply.php?do=newreply&p=1879811", _
        NewWindow:=True

End Sub

HTH

cheers for your help