macro to remove comment arrow only

[Howardc1001]

I would like a macro to remove the comment arrows only on sheet "Macro'


I would also like a macro to restore the comment arrow If necessary


Your assistance is most appreciated

[mostman]

Application.DisplayCommentIndicator = xlNoIndicator
Application.DisplayCommentIndicator = xlCommentIndicatorOnly
Application.DisplayCommentIndicator = xlCommentAndIndicator

[Howardc1001]

Thanks for the help. None of these options worked

I have attached Sample Data. I only need to remove the line with the arrow from the comment box. The comment box move remain visible

[torachan]

Use 'data validation' instead and put your 'message' in comment box, set to fire when clicking into relevant cells

[Howardc1001]

Thanks for your input torachan