- 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.