Hyperlinks:How can I removeBig all the hyperlinks from an Excel document

How can I removeBig all the hyperlinks from an Excel document

On a sheet by sheet basis you could run this code

Sub DelHyperLinks()
ActiveSheet.Hyperlinks.Delete
End Sub

If you want to iterate across all worksheets in a workbook try

Sub DelHyperLinks()
Dim wks As Worksheet
For each wks in Worksheets
wks.Hyperlinks.Delete
next wks
End Sub

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
[email protected]HIS


"BigDurk4x4" <[email protected]> wrote in message
news:[email protected]...
> How can I removeBig all the hyperlinks from an Excel document