comment text box

[Edgard \\kniriem]

I usually insert comments in almost every cell. When the comment text box
opens it always come with my name. If I delete my name in
Tools/options/general/user name, the comment text box opens with S_User
instead of my name. If I change my name for , let us say, a point, the
comment text box opens with ":." How can I do to make this comment text box
open completely blank and without formating?
TIA

 

[Gord Dibben]

Debra Dalgleish has provided code for this.

Copy/paste the code to your workbook or Personal.xls.

Assign the macro to a button and use that button to insert a comment.

Sub PlainComment()
Selection.AddComment text:=""
Selection.Font.FontStyle = "Regular"
Selection.Comment.Visible = True
End Sub

Gord Dibben Excel MVP

 

[Edgard Kniriem]

Thank you

--
Edgard Kniriem

Debra Dalgleish has provided code for this.

Copy/paste the code to your workbook or Personal.xls.

Assign the macro to a button and use that button to insert a comment.

Sub PlainComment()
Selection.AddComment text:=""
Selection.Font.FontStyle = "Regular"
Selection.Comment.Visible = True
End Sub

Gord Dibben Excel MVP