Comments

G

gumdale_dogs

Default cell 'comment'.
When attempting to insert a comment the dialogue box initially contains my
name. How do I stop this default entry?
 
B

Bryan Hessey

The comment is populated with the User Name from Tools, Options,
General, User Name, but to remove the name you may need to enter a
space in the Options window.
 
H

Héctor Miguel

hi, gumdale_dogs !
Default cell 'comment'.
When attempting to insert a comment the dialogue box initially contains my name.
How do I stop this default entry?
Click to expand...

you may use your 'own' custom AddComment macro ? i.e.
Sub myAddComment()
With ActiveCell
If Not .Comment Is Nothing Then Exit Sub
.AddComment ""
.Comment.Visible = True
ActiveSheet.Shapes(.Comment.Shape.Name).Select
SendKeys " {BS}"
Application.OnTime Now, "HideComment"
End With
End Sub
Private Sub HideComment()
ActiveCell.Comment.Visible = False
End Sub

hth,
hector.
 
Top