How to open a web page with a button?

[Marvin Hlavac]

I'd like to be able to have a button in my workbook that would open a
specific web page. How would I do it?

Thanks in advance.

 

[Don Guillett]

How about a hyperlink that you click on
1. Have your web page up
2. control+K
3. highlight the url in the browser address bar
4. touch enter
5. go back to your worksheet
6. touch enter again.

 

[Marvin Hlavac]

Hi Don,

Thanks, however for this specific project I would much rather a button
solution.

 

[Don Guillett]

Sub openurl()'assign to a button
ActiveWorkbook.FollowHyperlink _
Address:="http://yahoo.com", _
NewWindow:=True
End Sub

 

[Marvin Hlavac]

Don, you are a gentleman and I thank you very kindly. That is exactly what I
had in mind.

 

[Don Guillett]

glad to help