Excel - How to Remove Hyperlink Sprites (Image Elements)

Excel 2013
Windows 7

BACKGROUND: When I copied some data from a web page, one column has intermittent hyperlinks that appear as a small image of a magnifying glass.

When you RIGHT CLICK the mouse on one of them, the context menu gives the option to remove hyperlink or cut (and others). When I select the entire column and delete, the column is deleted but the sprites remain, but they now appear superimposed over the data in what used to be the adjacent column.

QUESTION: Since there are hundreds of these, I need a formula or macro way to remove them all from the original column. There is no other data in the original column to worry about.

By the way, what do you officially call these "sprites"? I've seen them before, and sometimes they are invisible where you can only find them by hovering your mouse around until the cursor turns to the hand pointer.
Jerry LAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rgonzo1971Commented:
Hi,

pls try

Sub Macro()
For Each shp In ActiveSheet.Shapes
    If shp.Type = msoPicture Or shp.Type = msoScriptAnchor Then
        shp.Delete
    End If
Next
End Sub

Open in new window

Regards
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jerry LAuthor Commented:
Perfect, thanks.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.