Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
"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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Random hyperlinks everywhere! | Excel Discussion (Misc queries) | |||
remove all Hyperlinks at one time. | Excel Discussion (Misc queries) | |||
Remove link fr a column of entries | Excel Discussion (Misc queries) | |||
Remove link fr a column of entries | Excel Discussion (Misc queries) | |||
Remove link fr a column of entries | Excel Discussion (Misc queries) |