Comments question

[Esradekan]

I wish to have cells with comments, but I dont want the little red
flag that sits on the top right of the cell. Can this be done? I
have excel 2007

TIA
Esra

 

[Nayab]

I wish to have cells with comments, but I dont want the little red
flag that sits on the top right of the cell.  Can this be done?  I
have excel 2007

TIA
Esra

U can use the following:
Application.DisplayCommentIndicator = xlNoIndicator

 

[Esradekan]

U can use the following:
Application.DisplayCommentIndicator = xlNoIndicator

Where do I put that?

Esra

 

[Nayab]

Where do I put that?

Esra

just run the following macro and then u can place the comments in any
of the cell without the comment tip:

sub hide_comment_tip()
Application.DisplayCommentIndicator = xlNoIndicator
end sub

 

[Esradekan]

just run the following macro and then u can place the comments in any
of the cell without the comment tip:

sub hide_comment_tip()
Application.DisplayCommentIndicator = xlNoIndicator
end sub- Hide quoted text -

- Show quoted text -

That doesnt seem to work, it takes away the 'comments' as well. All I
want to lose is the comments marker.

Any other suggestions?

All greatfully received.

TIA
Esra

 

[Nayab]

That doesnt seem to work, it takes away the 'comments' as well.  All I
want to lose is the comments marker.

Any other suggestions?

All greatfully received.

TIA
Esra- Hide quoted text -

- Show quoted text -

Hi Esra,

I hope the following helps:

Sub hide_comment_tip_display_comment()
Dim r As Range
Application.DisplayCommentIndicator = xlNoIndicator
Range("A1:A10").Select
For Each r In Selection
r.Select
With ActiveCell
If (.Comment Is Nothing) Then

Else
r.Comment.Visible = True
End If
End With
Next r
End Sub


You can change the range to suit your needs.

Rgds,
Nayab

 

[Esradekan]

Hi Esra,

I hope the following helps:

Sub hide_comment_tip_display_comment()
Dim r As Range
Application.DisplayCommentIndicator = xlNoIndicator
Range("A1:A10").Select
For Each r In Selection
    r.Select
    With ActiveCell
        If (.Comment Is Nothing) Then

        Else
            r.Comment.Visible = True
        End If
    End With
Next r
End Sub

You can change the range to suit your needs.

Rgds,
Nayab- Hide quoted text -

- Show quoted text -

That still takes away the comments

(

Esra

 

[Spiky]

That still takes away the comments

(

Esra

I thought I had replied to this. Maybe it's a different thread. Maybe
I am crazy.

I think the comments are still there, but the only way to access them
is to use Edit Comment. You can't take away the corner marker and
still have the hover-pop-up function work. So you would have to know
which cells have comments.

And, at least in Excel 2003, you can turn this on and off in Options.
Doesn't require VBA.

 

[Esradekan]

I thought I had replied to this. Maybe it's a different thread. Maybe
I am crazy.

I think the comments are still there, but the only way to access them
is to use Edit Comment. You can't take away the corner marker and
still have the hover-pop-up function work. So you would have to know
which cells have comments.

And, at least in Excel 2003, you can turn this on and off in Options.
Doesn't require VBA.- Hide quoted text -

My original question was

"I wish to have cells with comments, but I dont want the little red
flag that sits on the top right of the cell. Can this be done"

So the answer then would be - "no"

Thank You

Esra

 

[Gord Dibben]

The answer would be "yes"

They just won't pop-up when you hover.


Gord Dibben MS Excel MVP

 

[Nayab]

The answer would be "yes"

They just won't pop-up when you hover.

Gord Dibben  MS Excel MVP








- Show quoted text -

Esra,
I am not sure how it is not working. I have tested the code I had
posted and it gives me comments without the comment tip.

If you still have issues, send me the sample excel file and I will
test it at my end.

Rgds