Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
short cut for comment background
Adding pictures to the background of comments has particular utility to me.
Is there a shortcut besides adding a comment, right-clicking on the edge, format the comment, select the colors and lines tab, choose the color dropdown, select fill effects, choose the picture tab, and select picture. By my best count, that is around 8 steps. I can't even train a monkey to do that. Any ideas? thanks, Andy |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
short cut for comment background
I actually found something close on contextures
http://www.contextures.com/xlcomments03.html#Picture But I have no idea how to modify it to be able to grab jpg files off the server. "AJB" wrote: Adding pictures to the background of comments has particular utility to me. Is there a shortcut besides adding a comment, right-clicking on the edge, format the comment, select the colors and lines tab, choose the color dropdown, select fill effects, choose the picture tab, and select picture. By my best count, that is around 8 steps. I can't even train a monkey to do that. Any ideas? thanks, Andy |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
short cut for comment background
Have a browse at Debra Dalglesish's site.
http://www.contextures.on.ca/xlcomments03.html Couple of routines for inserting pictures. One from a file list and one from a selection. Gord Dibben MS Excel MVP On Wed, 25 Nov 2009 12:18:01 -0800, AJB wrote: Adding pictures to the background of comments has particular utility to me. Is there a shortcut besides adding a comment, right-clicking on the edge, format the comment, select the colors and lines tab, choose the color dropdown, select fill effects, choose the picture tab, and select picture. By my best count, that is around 8 steps. I can't even train a monkey to do that. Any ideas? thanks, Andy |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
short cut for comment background
Gord - the file insertion from a selection is very close to what I am looking
for. However, that macro inserts pictures that are already in the document. I am having a difficult time getting pictures in, in order to run the macro. thanks, Andy "Gord Dibben" wrote: Have a browse at Debra Dalglesish's site. http://www.contextures.on.ca/xlcomments03.html Couple of routines for inserting pictures. One from a file list and one from a selection. Gord Dibben MS Excel MVP On Wed, 25 Nov 2009 12:18:01 -0800, AJB wrote: Adding pictures to the background of comments has particular utility to me. Is there a shortcut besides adding a comment, right-clicking on the edge, format the comment, select the colors and lines tab, choose the color dropdown, select fill effects, choose the picture tab, and select picture. By my best count, that is around 8 steps. I can't even train a monkey to do that. Any ideas? thanks, Andy . |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
short cut for comment background
I have foolishly overlooked insert - picture in the main menu. Gosh. This
will make Debra's solution perfect. "AJB" wrote: Gord - the file insertion from a selection is very close to what I am looking for. However, that macro inserts pictures that are already in the document. I am having a difficult time getting pictures in, in order to run the macro. thanks, Andy "Gord Dibben" wrote: Have a browse at Debra Dalglesish's site. http://www.contextures.on.ca/xlcomments03.html Couple of routines for inserting pictures. One from a file list and one from a selection. Gord Dibben MS Excel MVP On Wed, 25 Nov 2009 12:18:01 -0800, AJB wrote: Adding pictures to the background of comments has particular utility to me. Is there a shortcut besides adding a comment, right-clicking on the edge, format the comment, select the colors and lines tab, choose the color dropdown, select fill effects, choose the picture tab, and select picture. By my best count, that is around 8 steps. I can't even train a monkey to do that. Any ideas? thanks, Andy . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do you add background color to a comment box | Excel Discussion (Misc queries) | |||
Extracting background image from a comment | Charts and Charting in Excel | |||
Change background & foreground colors in Comment box | Excel Discussion (Misc queries) | |||
change comment color in Excel when background is the same | Excel Discussion (Misc queries) | |||
Is there a short cut key that allows you to toggle between comment | Excel Discussion (Misc queries) |