Thread: macro to change a name of a hyperlink
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
Don Guillett[_4_] Don Guillett[_4_] is offline
external usenet poster
  
Posts: 2,337
Default macro to change a name of a hyperlink
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




Reply With QuoteReply With Quote