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