Can a small GIF or JPG image be stored inside of a cell, or somehow otherwise associated with it?
Many Thx
Can a small GIF or JPG image be stored inside of a cell, or somehow otherwise associated with it?
Many Thx
There are a couple different ways you could do this. The first would be to
select "Insert" from the menu bar and then "Picture", then "From File".
Select your GIF or JPG and then resize and place on your sheet where you
want. If you right-click on that picture, and then select "Format Picture"
then go to the "Properties" Tab, you can set it to move with cells. Thus it
won't really be associated with any particular cell, but its positioning will
stay relative to the cell you've place it on.
The second method would be to insert a Comment into the cell. Select
"Insert" from the menu bar, then "Comment". This creates a little balloon
window that appears whenever you move the mouse over that cell. Then go back
to the "Insert" menu and select "Edit Comment". Delete any text that is in
the Comment Window then click the outer edge of the comment (so you are no
longer editing the text within). Then right-click the edge and select
"Format Comment". Then select the "Colors and Lines" Tab and for Fill Color
choose "Fill Effects..." Then select the "Picture" tab and choose your
picture file.
HTH,
Elkar
"tx12345" wrote:
>
> Can a small GIF or JPG image be stored inside of a cell, or somehow
> otherwise associated with it?
>
>
>
> Many Thx
>
>
> --
> tx12345
> ------------------------------------------------------------------------
> tx12345's Profile: http://www.excelforum.com/member.php...o&userid=24776
> View this thread: http://www.excelforum.com/showthread...hreadid=502228
>
>
The cell comment idea was perfect.
Many Thx!
I had another related question
I can manually get the pic into the comment but when I try to use a macro to automate the process it keeps getting hung up. I recorded the following in the exact order:
but it keeps getting hung up here:Please Login or Register to view this content.
when I try to execute the macro. Have any ideas?Please Login or Register to view this content.
Thx
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks