Insert a picture in the COMMENT window

J

Juan Pablo González

MrExcel MVP

Joined

Feb 8, 2002

Messages

11,959

• Jun 13, 2002

• #2

Insert, no. BUT, it IS a shape, you can define the background image of it, simulating an inserted image.

 

Upvote 0

Damon Ostrander

MrExcel MVP

Joined

Feb 17, 2002

Messages

4,239

• Jun 13, 2002

• #3

Hello DraftThe3Car,

No, it is not possible to insert a picture into a Comment object in Excel. However, it IS possible to have a picture pop up in a prescribed relationship to a comment when a cell is selected and the comment appears. It could thus be made to appear that the picture is attached to the comment. I could probably be persuaded to provide the code for this if you are interested.

Damon

 

Upvote 0

S

stone

Board Regular

Joined

Apr 25, 2002

Messages

138

• Jun 13, 2002

• #4

Yes You can doit.

Insert coment.
Select the frame of the comment->format comment.
select colors and lines,sellect fill effects in the FILL area, and select picture
(then the picture is a background)

Hope thius helps
BK
Stulli

 

Upvote 0

S

stone

Board Regular

Joined

Apr 25, 2002

Messages

138

• Jun 13, 2002

• #5

Yes You can doit.

Insert coment.
Select the frame of the comment->format comment.
select colors and lines,sellect fill effects in the FILL area, and select picture
(then the picture is a background)

Hope thius helps
BK
Stulli

 

Upvote 0

Damon Ostrander

MrExcel MVP

Joined

Feb 17, 2002

Messages

4,239

• Jun 13, 2002

• #6

Juan Pablo,

I wasn't aware of the capability to put a background image in a Shape object. I've searched the helps but can't find any Shape properties named "Background...", etc. I know that worksheets now have a background picture capability--I'm wondering if you were thinking of this, or perhaps the Shape which is of type msoPicture? Or perhaps it is a new capability in Excel XP? At any rate, can you shed some more light on this?

Best regards.

Damon

 

Upvote 0

Damon Ostrander

MrExcel MVP

Joined

Feb 17, 2002

Messages

4,239

• Jun 13, 2002

• #7

Thanks BK,

I learned something! Looks like Juan was right as well. You're off the hook Juan.

Damon

 

Upvote 0

J

Juan Pablo González

MrExcel MVP

Joined

Feb 8, 2002

Messages

11,959

• Jun 13, 2002

• #8

Sure Damon, (Glad to do it too!)

Here at work I have 2000, so, able to do it in here too. Select the comment, go to the Fill button, select Fill Effects, and go to the last tab, "Image", in there you can select an image to use as the background of that. Comments are just an ordinary Shape (Type 4 if I remember right, msoComment)

That simple ! very cool thing too !

 

Upvote 0

K

klb

Well-known Member

Joined

Apr 3, 2002

Messages

821

• Jun 13, 2002

• #9

This can be done in Excel97 as well.

 

Upvote 0

D

DraftThe3Car

New Member

Joined

Jun 6, 2002

Messages

11

• Jun 13, 2002

• #10

Ok, ok, everyone is getting all this but.....me!

1) I inserted a comment.
2) I r-clicked on the comment and...
3) Selected Format Comment

...after that, the ONLY window I get reads FONT. I'm not seeing all the stuff you fella's are.

Can you kindly be a bit more descriptive for us rookies?

Thanks in advance.

 

Upvote 0