Copying Image From Cell Comment

[Ranger006]

I've got a problem with images in comments and I was hoping for some help. I've been dabbling with creating a macro that allows a user to select an image from "my pictures" and then automatically inserting that image into a cell comment. Unfortunately, while the macro works great, we underestimated the popularity of the spreadsheet and now there are hundreds of pictures and the file has become too large. Is there a way to copy the image from the comment into a file structure and then replace the image in the comment with a link to the image's new path. Not sure if this can be done but I need to do something to manage the size of the spreadhseet while still allowing images to be identified with the cell. By the way, this site is fantastic and has taught me a lot. Thanks!

 

[BRWP]

I do not have an answer for you and for that I am sorry but I am trying to upload a pdf into a cell comment. Is this possible with out writing a macro?

Thanks!