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

On Jun 17, 1:00*pm, Esradekan wrote:
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

On Jun 17, 8:13*pm, Nayab wrote:
On Jun 17, 1:00*pm, Esradekan wrote:

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


Where do I put that?

Esra

On Jun 17, 5:12*pm, Esradekan wrote:
On Jun 17, 8:13*pm, Nayab wrote:

On Jun 17, 1:00*pm, Esradekan wrote:

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

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

On Jun 18, 12:16*am, Nayab wrote:
On Jun 17, 5:12*pm, Esradekan wrote:





On Jun 17, 8:13*pm, Nayab wrote:

On Jun 17, 1:00*pm, Esradekan wrote:

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

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

On Jun 18, 11:56*am, Esradekan wrote:
On Jun 18, 12:16*am, Nayab wrote:





On Jun 17, 5:12*pm, Esradekan wrote:

On Jun 17, 8:13*pm, Nayab wrote:

On Jun 17, 1:00*pm, Esradekan wrote:

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

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