Creating button as a hyperlink

  • Thread starter Thread starter Hall
  • Start date Start date
H

Hall

How do I create a button on my worksheet so when the user clicks it, he's
taken to a specified hyperlink?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top