Hi all
I would like to be able to automatically print the hyperlink target in
the following code without opening it. Is this possible?

If SheetExists("SLA") Then
Range("B25").Select
ActiveCell.FormulaR1C1 = "Yes"
h = h + 1
With Worksheets(1)
..Hyperlinks.Add .Range("B25"),
"http://abcgis1.ashford.gov.uk/website/locplan/EN27.html"
..Hyperlinks(h).TextToDisplay = "Yes"
End With
Else
Range("B25").Select
ActiveCell.FormulaR1C1 = "No"
End If

Thanks in advance for any suggestions.
Regards
Liz


--
LizS
------------------------------------------------------------------------
LizS's Profile: http://www.excelforum.com/member.php...o&userid=28991
View this thread: http://www.excelforum.com/showthread...hreadid=517239