LinkBack URL
About LinkBacks
I tried "Go To" and Special but I cant seem to figure out a way to remove the Hyper-Link from all the images in my spread sheet at once. It will take me forever to remove them individually. Any Ideas?
Thanks!
I tried "Go To" and Special but I cant seem to figure out a way to remove the Hyper-Link from all the images in my spread sheet at once. It will take me forever to remove them individually. Any Ideas?
Thanks!
do you require objects only?
can you do everything?
a lot less work to do just everything on the sheet that is all
Please Login or Register to view this content.
Last edited by humdingaling; 09-27-2013 at 02:56 AM.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
ok was a bit easier than i thought it would be to do just objects
Please Login or Register to view this content.
That did the trick, thanks brother !
Another way: Select all cells that have the hyperlinks that you want to clear. Click on the Home Tab, Clear, Hyperlinks.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
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!
Last edited by Wizard Serge; 10-23-2013 at 06:50 AM. Reason: additional info
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.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks