Mass Change of Text to Display in Hyperlink to actual address

		Microsoft Office Forums > Microsoft Excel > Excel
Mass Change of Text to Display in Hyperlink to actual address

10-17-2014, 10:26 PM

macropod

Windows 7 64bit Mass Change of Text to Display in Hyperlink to actual address

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,385

Changing the display text for all hyperlinks requires a macro:

Code:

Sub Demo()
Dim hLnk As Hyperlink
For Each hLnk In ActiveSheet.Hyperlinks
    hLnk.TextToDisplay = hLnk.Address
Next
End Sub

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Change Text To Hyperlink	abraxis	Outlook	0	10-09-2014 08:24 AM
Add link to email address that hides the actual address or makes it inaccessible to online bots	richiebabes	Word	1	09-03-2014 03:22 PM
Delete specific mass text on document	JadeRisley	Word	4	07-17-2013 11:11 PM
How do you mass change "Text to Display" on hyperlinks	lvillanueva5	Mail Merge	1	09-10-2012 05:32 PM
Can't change period when adjusting actual time in Web Access	chip_saffire	Project	0	10-04-2011 12:05 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:15 AM.