remove hyperlinks
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" 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 |
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 |
All times are GMT +1. The time now is 04:00 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com