We use a web-based report that is exported to Excel. We have no control over the way it's exported and it's full of hyperlinks linked to cells and shapes (pictures). I've been asked to come up with some VB code to remove the hyperlinks, amongst other things.
worksheet.hyperlinks.delete works, but it removes the shapes, which I need to keep. I can copy each shape to to another worksheet, then put them back after I've deleted the links, but it's painfully slow.
Is there a better way of getting rid of the hyperlinks while keeping the shapes?
Thanks in advance
worksheet.hyperlinks.delete works, but it removes the shapes, which I need to keep. I can copy each shape to to another worksheet, then put them back after I've deleted the links, but it's painfully slow.
Is there a better way of getting rid of the hyperlinks while keeping the shapes?
Thanks in advance
