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