View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
glenn glenn is offline
external usenet poster
 
Posts: 122
Default Command Button VB Code w/hyperlinks

I did get this to work - I misinterpreted the word wrap as to syntax....my bad.
Thanks

"Dave Peterson" wrote:

ThisWorkbook.Hyperlinks.FollowHyperlink Address:="Http://www.microsoft.com"

You may want to use a control from the Drawing toolbar (prettier shapes???) and
rightclick and use Assign hyperlink.

Glenn wrote:

This should be easy, but...
I want to hard code a hyperlink (URL) in the code for a command button, via
Private Sub CommandButton1_Click()

what code goes here....?
End Sub

I'm using Excel 2003.
By clicking the command button I want to open a browser and connect to the
URL coded.


--

Dave Peterson