View Single Post
  #2   Report Post  
Don Guillett
 
Posts: n/a
Default

the macro recorder is your friend
Sub Macro5()
'
' Macro5 Macro
' Macro recorded 9/16/2005 by Don Guillett
'

'
Selection.Hyperlinks(1).TextToDisplay = "my yahoo 11"
End Sub
now change to
Selection.Hyperlinks(1).TextToDisplay = inputbox("enter name")'"my yahoo 11"
--
Don Guillett
SalesAid Software

"Greg B" wrote in message
...
Is there a way to change what is displayed on a hyperlink in vb code? I
would like for a input box to appear and ask what name would you like to
call the link?

Thanks

Greg