How to upload WITH Images (Hyperlinks)

macropod · #3 04-01-2014, 06:05 PM

You may be able to achieve what you're after by deleting the Hyperlink Address, retaining just the SubAddress. You can do that with a macro using code like:

Code:

Sub Test()
Dim xlWkSht As Worksheet, HLnk As Hyperlink
For Each xlWkSht In ThisWorkbook.Worksheets
  For Each HLnk In xlWkSht
    With HLnk
      .Address = ""
      .ScreenTip = .SubAddress
    End With
  Next
Next
End Sub

Test on a copy of your workbook before doing it on the one you want to use.

PS: A little patience wouldn't go astray. A follow-up less than an hour after the original post isn't likely to endear you to anyone...

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
microsoft office upload center msosync.exe	q_auth6	Office	5	11-26-2013 02:49 PM
Hyperlinks on images in oft template files	ianhornby	Outlook	1	01-10-2012 05:47 PM
MS Word 2007 error when trying to upload .doc or .docx to a webpage	heretical1	Word	0	10-06-2010 12:20 PM
Image Upload template.	vvnaga	Word	0	12-29-2009 02:51 AM
Please help .. cannot upload	davee9th	Misc	0	07-02-2006 05:45 AM