#1
|
|||
|
|||
Quick way of adding an image in a comment (popup picture)
I work regularly on a particular type of Excel document that requires me to insert images so that my colleagues can understand what I'm referring to (related to mechanical design and a picture speaks a 1000 words as they say).
In order to keep the document neat and tidy, I insert comments and then add the image to the comment (technically it's just the background of the comment that is filled with the image I select). See Placing a Picture in a Comment for the exact method of how to do this. This whole process is rather slow and laborious when it has to be repeated over and over. Can this process by done via a macro? I'm not too hot on macros unfortunately. My understanding is that the procedure can be recorded via a macro and a button assigned to repeat the act again? [IMG][/IMG] |
#2
|
||||
|
||||
Have a look at Excel Comments - Macros and search for "Insert Selected picture onto comment"
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Thanks a million.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Adding Quick Parts Programmatically | eduzs | Word VBA | 3 | 05-22-2017 12:30 AM |
Finding better icon picture for macros in Quick Access Toolbar | tesoke | Word | 2 | 01-25-2016 10:31 PM |
Adding tab's add-in items to the quick acess toolbar | Dimsok | Word | 6 | 09-17-2014 06:52 AM |
Powerpoint automatically changing picture size when adding a picture (2010) | One_Life | PowerPoint | 7 | 01-20-2012 06:57 AM |
Adding Image into a excel cell and adding a hyperlink to the image | saravananiyyanar | Excel | 3 | 05-04-2011 08:31 AM |