mouse over pop up

O

oxicottin

Is there any way I can run my mouse over a section and have a pop up appear
"say a small picture" for a few seconds and then close? Im am not good at
macros so if so can you explain in steps?

Thanks!
 
T

Teethless mama

Insert > Comment > Back spaces to clear inside the comment > click out the
border > right click format comment > Colors and Lines tab > click the drop
down under Fill Color:> select Fill Effects > select Picture tab > click on
Select Picture button > select any picture you want > click Insert >Ok >OK

Evertime you your mouse over the comment the picture will pop up
 
O

oxicottin

Thanks I now I know how to do this but even by adding my picture to a comment
box there still is that little triange in the corner. How do you get rid of
it? Thanks for your reply!!!
 
D

Dave Peterson

The red indicator indicates that there is a comment in that cell.

You can use:
tools|Options|View tab|Comment section

to hide the comment, to show the indicator only (the comment will appear when
you mouse over the cell) or to show both the indicator and the comment.

You'll notice that there isn't an option to hide the comment indicator, but
still allow the comment to appear.
 
D

drmikec

Dave Peterson said:
The red indicator indicates that there is a comment in that cell.

You can use:
tools|Options|View tab|Comment section

to hide the comment, to show the indicator only (the comment will appear when
you mouse over the cell) or to show both the indicator and the comment.

You'll notice that there isn't an option to hide the comment indicator, but
still allow the comment to appear.
Click to expand...
 
D

drmikec

Sorry, a little too quick on the Post button. How does Microsoft do the
little info box on their canned templates? Are they not comments? There are
no red triangles in those fields. Thanks.
 
D

Dave Peterson

Are there green triangles on the left side?

Maybe you're seeing the error/warning messages from Tools|Options|Error
Checking.
 
G

Gord Dibben

Those are most likely Data Validation messages.

Select a cell with the pop-up and check for DV.


Gord Dibben MS Excel MVP
 
D

drmikec

You nailed it, Gord! Thanks. It's been bugging me for a while. Now I can
get rid of all those clunky comments when I just want to add instructions for
a field!
Best regards,

Mike
 
Top