How Do I Add/Remove links with VBA?

I want to remove all the hyperlinks in my spreadsheet That's super easy - just right click on the column with the hyperlinks and click "Remove Hyperlinks". A problem arises when you want to add them quickly back in, as there is, unfortunately, no option of doing so, other than right-clicking on a link after …