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