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.
Dave wrote:
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
--
Dave Peterson
|