"Dave" wrote in message
...
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
|