Creating button as a hyperlink

H

Hall

How do I create a button on my worksheet so when the user clicks it, he's
taken to a specified hyperlink?
 
H

Harald Staff

Question is "how do I create a button", how make something happen when
someone clicks a button, or how to go to a website from within Excel ?

The latter is called followhyperlink:

Sub test()
ActiveWorkbook.FollowHyperlink "http://www.nonsense.com"
End Sub

HTH. Best wishes Harald
 
Top