- Loop through all worksheets in the workbook.
- In every worksheet loop through the hyperlinks (they form a collection).
- Delete each hyperlink (that's a method of the hyperlink object).
Ten lines, I'd say, 15 at most. Ten minutes work, at most, for someone versed in VBA.
Persons not knowing how to program a repeatable task, have to repeat it manually, I'm afraid.
Hope this helps.
I have an excel workbook with many cells containing hyperlinks.
I want to remove all the hyperlinks from this work book.
Excell help file sugested a way, but you have to select them all first, and there are too many to select them one at a time, any any range you select will have some cells with, and some without the hyperlinks.
Does anyone have any suggestions here?