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
HIS


"BigDurk4x4" wrote in message
...
How can I removeBig all the hyperlinks from an Excel document