View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Elkar
 
Posts: n/a
Default Problem inserting a picture in Excel that ONLY shows when clicked

You could insert the picture into a Comment. This will show the picture
whenever the mouse pointer is hovering over that cell.

Select your cell
Right-click and select "Insert Comment
Delete any default text that appears
Right-click the border of the comment and select "Format Comment"
Select the "Colors and Lines" tab
For the Fill Color, select "Fill Effects"
Select the "Picture" tab
Click "Select Picture"
Find your picture fill and click "Insert"
Click OK
Click OK

HTH,
Elkar


"Blackgammon" wrote:

Hi

Using Excel 2003 as database. Want to insert client's picture(s) in their
file for easy reference.

How do I insert a picture that ONLY shows when I click on it. Right now,
when I insert a jpg, the picture bleeds over the other rows/columns and is
always there. When I move away from the cell, I want the picture to disappear.

Cheers!