How Do I Remove Hyper-Link from ALL Objects (Images) In Every Cell at once?

do you require objects only?
can you do everything?

a lot less work to do just everything on the sheet that is all

Sub RemoveHyperlinks() 'Remove all hyperlinks from the active sheet
ActiveSheet.Hyperlinks.Delete
End Sub

ok was a bit easier than i thought it would be to do just objects

Sub DeleteObjectHyperlinks()
    With ActiveSheet
        For Each Shape In .Shapes
            .Hyperlinks.Delete
        Next Shape
    End With
End Sub

Hello there!

I'm new to this forum but I'm facing exactly the same. Somehow the above macro doesn't work for me.
I have a sheet with hundreds of images that are copied in a cell via a macro. The macro looks into a folder of images, ties the right image to the an item code and resizes the image to fit the cell. Working great!
I'm trying now to remove the links from images in this sheet so that every image is part of the sheet and is not referred to via a link. The purpose for that is to be able to share the excel file without having to share the folder with all the images as well.

Any solutions?

Would be much appreciated!

Another way: Select all cells that have the hyperlinks that you want to clear. Click on the Home Tab, Clear, Hyperlinks.

Wizard Serge,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.