How can I removeBig all the hyperlinks from an Excel document
N Nick Hodge Nov 4, 2005 #2 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]
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]
