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