I have a worksheet that enables users to attach files in it.
I coded in VBA so that every time a user clicks the button, Excel will attach a document by inserting an object into the worksheet.

My problem is that I want the object to be appeared as a document icon, but I want the icon to be an image in my worksheet.
I know I can use the IconFileName attribute in ActiveSheet.OLEObjects.Add, but the image is in the worksheet which I don't have a separate image file link, and I want to keep it one document so that I don't need to send two files to other people.

Below is the coding.

Please Login or Register  to view this content.
Here is the file. The icon is in F3,F4.
attach.xlsm


Big thanks to all experts!