Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove multiple hyperlinks in an Excel spreadsheet
I've had a hyperlink problem in my Excel files for ages: false hyperlinks had
been created (even in empty cells) and were multiplying regularly whenever I inserted new lines. How can I delete all hyperlinks in a sheet at once and not have to delete them cell by cell? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove multiple hyperlinks in an Excel spreadsheet
Select the range to clean up (ctrl-a a few times will select all the cells)
hit alt-f11 (to get to the VBE) hit ctrl-g (to see the immediate window) type this and hit enter: selection.hyperlinks.delete Leon wrote: I've had a hyperlink problem in my Excel files for ages: false hyperlinks had been created (even in empty cells) and were multiplying regularly whenever I inserted new lines. How can I delete all hyperlinks in a sheet at once and not have to delete them cell by cell? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove multiple hyperlinks in an Excel spreadsheet
Hi Dave,
How do I run the function. By pressing the "Enter" I had a run time error -'-2147417848(80010108)'; Automation error. The object invoked has disconnected from client. "Dave Peterson" wrote: Select the range to clean up (ctrl-a a few times will select all the cells) hit alt-f11 (to get to the VBE) hit ctrl-g (to see the immediate window) type this and hit enter: selection.hyperlinks.delete Leon wrote: I've had a hyperlink problem in my Excel files for ages: false hyperlinks had been created (even in empty cells) and were multiplying regularly whenever I inserted new lines. How can I delete all hyperlinks in a sheet at once and not have to delete them cell by cell? -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove multiple hyperlinks in an Excel spreadsheet
I'm not sure why you got that error.
I'd close excel and retry it (but that's just a guess). Leon wrote: Hi Dave, How do I run the function. By pressing the "Enter" I had a run time error -'-2147417848(80010108)'; Automation error. The object invoked has disconnected from client. "Dave Peterson" wrote: Select the range to clean up (ctrl-a a few times will select all the cells) hit alt-f11 (to get to the VBE) hit ctrl-g (to see the immediate window) type this and hit enter: selection.hyperlinks.delete Leon wrote: I've had a hyperlink problem in my Excel files for ages: false hyperlinks had been created (even in empty cells) and were multiplying regularly whenever I inserted new lines. How can I delete all hyperlinks in a sheet at once and not have to delete them cell by cell? -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I remove a constant from an excel spreadsheet? | Excel Discussion (Misc queries) | |||
How do I remove a constant from an excel spreadsheet? | Excel Discussion (Misc queries) | |||
Hyperlinking to Excel 2000 with a linked spreadsheet | Excel Discussion (Misc queries) | |||
allow multiple users on excel spreadsheet | Excel Worksheet Functions | |||
How to remove all hyperlinks from a worksheet in Excel? | Excel Worksheet Functions |