Embedded objects query- Help Required!
Hi, I'm wondering if anyone can help me. I have a list of embedded PDF files within a table but I would like to return a specific embedded file based on a cell value. For example I have an embedded PDF for Product 1 in the table which I would like to be pulled through on a summary tab when product 1 is selected from a data validation list. Is this possible? I know it is possible with a vlookup when using hyperlinks to files, however unfortunately I cannot use hyperlinks in this scenario as this file will be going out externally. Any help and suggestions would be appreciated. thanks in advance Luke
pictures embedded in the comment in a cell disappear after I open the workbook up after saving and c
I have spent hours embedding PDF files in a Workbook and then embedding a picture of the PDF file in the comments in a cell so all you have to do is scroll across the cell next to the PDF icon to see exactly what the PDF file is. Only to save it then open it back up in the morning to find my pictures in the comments gone and the PDF icon to be transparent except the letter and the logo. I need help to find out what is the best format to save and what could be wrong with what I am doing. Thank you for any feed back it is greatly appreciated.