It works great Have made little changes with your code. I tried the macro
builder but it remained blank.

Thanks again

Greg
"Don Guillett" wrote in message
...
glad to help

--
Don Guillett
SalesAid Software

"Greg B" wrote in message
...
thanks Don

"Don Guillett" wrote in message
...
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