remove hyperlinks

[Guest]

An outside application exports data to an Excel spreadsheet, but all the
numbers (part numbers in this case) are created as hyperlinks. My
spreadsheet can contain hundreds of numbers. Is there any way I can remove
the hyperlinks en masse rather than one by one? I can't change the program
that creates the spreadsheet.

Thanks,

Dave

 

[Andy Brown]

An outside application exports data to an Excel spreadsheet, but all the
numbers (part numbers in this case) are created as hyperlinks. My
spreadsheet can contain hundreds of numbers. Is there any way I can remove
the hyperlinks en masse rather than one by one? I can't change the program
that creates the spreadsheet.

Yes Dave, with a simple macro:

Sub Macro1()
ActiveSheet.Hyperlinks.Delete
End Sub

Rgds,
Andy

 

[Dave Peterson]

Hit ctrl-A (twice in xl2003) to select the whole sheet.

Hit alt-F11 to see the VBE
hit ctrl-g to see the immediate window

type this and hit enter

selection.hyperlinks.delete

Then alt-f11 back to excel to see if it worked.