I have a couple of workbooks that have hyperlinks scattered throughout the
worksheet (many worksheets). Can I programtically remove all these with a
macro?
I have a couple of workbooks that have hyperlinks scattered throughout the
worksheet (many worksheets). Can I programtically remove all these with a
macro?
Sub hypergone()
Selection.Hyperlinks.Delete
End Sub
Just select the range you want to clean and run the macro
--
Gary's Student
"dthmtlgod" wrote:
> I have a couple of workbooks that have hyperlinks scattered throughout the
> worksheet (many worksheets). Can I programtically remove all these with a
> macro?
>
>
>
>
Sub RemoveLinks()
Dim ThisSheet as Worksheet, ThisLink as Hyperlink
For Each ThisSheet in ThisWorkbook.Worksheets
For Each ThisLink in ThisSheet.Hyperlinks
ThisLink.Delete
Next ThisLink
Next ThisSheet
End Sub
--
- K Dales
"dthmtlgod" wrote:
> I have a couple of workbooks that have hyperlinks scattered throughout the
> worksheet (many worksheets). Can I programtically remove all these with a
> macro?
>
>
>
>
To delete all the hyperlinks from activsheet,
ActiveSheet.Hyperlinks.Delete
Regards,
Shah Shailesh
http://members.lycos.co.uk/shahweb/
http://in.geocities.com/shahshaileshs/
(Excel Add-ins Page)
*** Sent via Developersdex http://www.developersdex.com ***
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks