Hello Steve,
Welcome to the Forum!
There is no built in worksheet function to do this. I have created a UDF (User Defined Function) that will take a picture (bmp, gif, or jpg format) from file,and place into a cell as a comment. This hides the picture until the the mouse enters the cell. This frees the cell up for other use.
To Install the Macro:
1. Copy the Macro code above using CTRL+C
2. Open Excel and Right Click on any Sheet Tab
3. Click on View Code in the pop up menu
4. Use ALT+I to activate the VBE Insert Menu
5. Press the letter m to insert a Standard Module
6. Paste the macro code using CTRL+V
7. Save the macro using CTRL+S
8. Close the VBE and return to excel using ALT+Q
UDF Example
Sincerely,
Leith Ross
Bookmarks