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

"oxicottin" wrote:

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!

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!!!

"Teethless mama" wrote:

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

"oxicottin" wrote:

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!

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.

oxicottin wrote:

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!!!

"Teethless mama" wrote:

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

"oxicottin" wrote:

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!

--

Dave Peterson

"Dave Peterson" wrote:

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.

oxicottin wrote:

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!!!

"Teethless mama" wrote:

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

"oxicottin" wrote:

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!

--

Dave Peterson

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.

"drmikec" wrote:



"Dave Peterson" wrote:

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.

oxicottin wrote:

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!!!

"Teethless mama" wrote:

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

"oxicottin" wrote:

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!

--

Dave Peterson

Are there green triangles on the left side?

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

drmikec wrote:

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.

"drmikec" wrote:



"Dave Peterson" wrote:

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.

oxicottin wrote:

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!!!

"Teethless mama" wrote:

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

"oxicottin" wrote:

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!

--

Dave Peterson


--

Dave Peterson

Those are most likely Data Validation messages.

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


Gord Dibben MS Excel MVP

On Wed, 30 May 2007 19:26:01 -0700, drmikec
wrote:

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.

"drmikec" wrote:



"Dave Peterson" wrote:

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.

oxicottin wrote:

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!!!

"Teethless mama" wrote:

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

"oxicottin" wrote:

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!

--

Dave Peterson

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

"Gord Dibben" wrote:

Those are most likely Data Validation messages.

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


Gord Dibben MS Excel MVP

On Wed, 30 May 2007 19:26:01 -0700, drmikec
wrote:

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.

"drmikec" wrote:



"Dave Peterson" wrote:

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.

oxicottin wrote:

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!!!

"Teethless mama" wrote:

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

"oxicottin" wrote:

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!

--

Dave Peterson