Hyperlink added to an activex control button

D

Dimmer

Hi guys,
maybe a very basic question, but still: How do I make a button open a
hyperlink in the browser when someone clicks on it?

Thanks!
 
D

Dave Peterson

You could use some code--just double click on that button in design mode. Your
code will look something like:

Option Explicit
Private Sub CommandButton1_Click()
ThisWorkbook.FollowHyperlink "http://www.microsoft.com"
End Sub

ps. If you use buttons from the forms toolbar, you can right click on them and
choose assign hyperlink.
 
Top