mouse over pop up

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
 
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!!!
 
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.
 
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...
 
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.
 
Are there green triangles on the left side?

Maybe you're seeing the error/warning messages from Tools|Options|Error
Checking.
 
Those are most likely Data Validation messages.

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


Gord Dibben MS Excel MVP
 
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
 
Back
Top