Making the Comment Indicator Disappear

[BLB]

I have a worksheet with comments in many cells. I have hidden th
comments (showing the indicator only) so that when the cursor passe
over the cell, you see the comment. I still want this to happen, BUT
don't want to see the red corner in the cell.

Is there a way (possibly in VBA?) to get rid of the red corner an
still see the comment when the cursor passes over the cell?

Thanks Bunche

 

[Greg Koppel]

Tools/Options,View tab, Comments section, None radio button

 

[BLB]

I have tried that. Unfortunately, when you select "None" is does no
make the comment viewable at all unless you go in to edit the comment.
I still want the comment to pop up when the cursor is on the cell,
just don't want to see the red corner in the cell.

Thanks

 

[David McRitchie]

Could you use a double click macro, it will put the comment
itself into edit, but will go away when you select another cell.

To install worksheet event macro:
Unlike regular macros which are installed in regular modules, Worksheet Events
are installed with the worksheet by right-clicking on the sheettab, choose 'view code',
and then paste in your macro.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Application.CommandBars("Reviewing").Visible = False
Application.DisplayCommentIndicator = 0
End Sub

 

[Rowie]

I realise you already have comments, but in Data Validation and in th
Input message area, you can put in a comment which will only show up i
you select the cell, is this a possible work around

 

[David McRitchie]

If you want to try that see table in in
http://www.mvps.org/dmcritchie/excel/ccomment.htm#code
code is not documented on my Cell Comment page, see it at
http://www.mvps.org/dmcritchie/excel/code/ccomment.txt

I wouldn't recommend exchanging comments to validation or
vice versa, but Rowie's suggestion does seem to fit the request best,
you will have to click on the cell rather than just hover over the cell.
And that definitely does not fit your "I still want this to happen",
concerning showing comment when hovering over the cell
(without selection).

In other words you would have to know where the comment is.
Though there is also a macro for selecting all comments,
and one for selecting all validations.

I like seeing the cell comment tag for cell comments myself.

CommentsFromValidationBox
Create Comments from Validation Messages
Conversion removes the cell Validations in the selection
CommentsToValidationBox Convert Comments to Validation Box Messages
for those that don't want to see comment tags
Conversion removes the Cell Comments in the Selection

 

[David McRitchie]

I guess since it requires extra work to obfuscate everything
you'd probably be better off with
Cell Comment indicator triangle, change color of, Stratos Malasiotis (e-mail address removed)
http://google.com/[email protected]
It doesn't really change the color it covers up the comment indicator with a
triangle a tad bigger.

 

[BLB]

David & Rowie,

Thanks so much for your suggestions! Inserting a white triangle shap
over the indicator actually works very well. When you're spreadshee
has a comment in almost every cell, it is hard to focus on anything bu
a million red triangles!

The data validation may work as well, but I haven't had a chance t
play around with that suggestion.

Thanks again,
Beck

 

[David McRitchie]

Hi Becky,
Lots of shapes can be a problem for Excel, I don't know if
that is going to be one shape, or millions. But I'd definitely
watch you file size. Lots of shapes was a problem before
Windows 2000 most definitely a problem before Win 98.
A million of any kind of objects is going to wipe out Excel ;-)

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

 

[BLB]

Thanks David,

Good to know. I will keep an eye on it. If it doesn't end up workin
than I will look at the data validation option or just deal with
million red triangles.

Beck