Show Excel comment on mouseover but not the comment indicator

[jrfauteux]

I have created an excel spreadsheet where all cells in a column of
data contain comments.

The comments provide additional information about a customer. For
example, the cell value is 'Pizza Hut', and the cell comment contains
store #, address, city.

Showing a comment on every cell creates a very busy looking
spreadsheet.
Is there a way to hide the indicators, but the cell comments still
popup on mouseover?

Thank you

John

 

[Billy Liddel]

Hello John

Comments will popup when you run a mouse over the cell. If you want a macro
to hide all the comments, this one is in the help file.

Sub hideComments()
Set cmt = ActiveSheet.Comments
For Each c In cmt
c.Visible = False
Next
End Sub

Hope this helps
Peter

 

[jrfauteux]

I want to hide the comment indicators (the red triangle on the right
of the cell) only. I want the comment to behave like a normal excel
comment, only I want to hide the fact that a comment exists in the
cell.

Thank you for your help!

 

[Susan]

tedious but will work - put a white triangle autoshape over the
comment triangle indicator................
or whatever color your background is (i'm assuming it's white).
will hide the comment triangle indicator, making it invisible. the
white triangle would have to be sized & placed precisely, so that it
doesn't mess up borders or anything else.
hth
susan

 

[Billy Liddel]

Adding to Susans idea - Debra Dalgleish shows how to do it with VBA @
http://www.contextures.com/xlcomments03.html#Indicator

Hope that this helps
Peter

 

[rb79]

Just registered to throw my idea into the hat. This is what I am going to do and may work in your case also.

Say you wanted to add a comment to cell B5.
Add a blank row right above row B and add the comment to the new cell B5.
Now make the row B exactly .1 pixel high. Add the text to C5 (that was originally B5).
Can do the same using a .1 pixel column depending on your situation.

 

[Daniel Smith]

Try using a Data Validation Input Message for your text, instead of a comment. You will have to click in the cell to show the text, but there is no indicator.

 

[bondjems26]

You can also use this power XL software for remove comment in excel files and make excel is easy.