When you insert a comment into Excel, your username is automatically inserted into the comment followed by a colon. For instance, if you log into your computer using the user name TrunkOfFunk. Your comments will all start with TrunkOfFunk:.
.
This annoys me to no end. Theoretically, this "feature" is supposed to tell you who inserted the comments. I don't think I have ever needed to know that Donna inserted a comment into cell B2. In my opinion, the user name just clutters up the comment.
.
If you share my distain for the forced username in comments, here is a small procedure that will go through all comments and remove the username. This is especially handy for those of you who have embarrasing user names like Lou Briccant.
Visual Basic:
-
Sub RemoveUserNames()
-
Dim MyComment As Comment
-
Dim I As Integer
-
-
'Start looping through comments
-
For Each MyComment In ActiveSheet.Comments
-
-
'Find the position number of the Colon & LineFeed character combination
-
I = InStr(1, MyComment.Shape.TextFrame.Characters.Text, ":" & vbLf)
-
-
'Use the position number to reset the comment text to all but the user name
-
If I> 0 Then
-
MyComment.Shape.TextFrame.Characters.Text = _
-
Mid(MyComment.Shape.TextFrame.Characters.Text, I + 2)
-
End If
-
-
'Go to the next comment
-
Next MyComment
-
-
End Sub
RELATED STUFF
- Mocking the ‘Merge & Center’ Icon
- VBE Tips I Wish I Knew 5 Years Ago
- Highlighting the Active Row and Column
- Why is Excel so Negative about Hiding Subtotals
- Why Replace the DOM Interface
- Running an Access Parameter Query from Excel
- Creating a Zoom Box in Excel
- Smart Scroll Bars in Excel
- Excel Zoom Box Font Size Follow Up
- Fun with Custom Lists
This will certainly help...thanks!
me too!!!!
me three!!!!
Me four
I used to think user names were a feature, because when I changed my username to God less people tended to argue with my comments.
But recently, people have been commenting back with "which one". So now I'm converted, if you'll pardon the pun.
we avoid the annoyance by setting: Options-->General->Usename.
If you have Usename in Comment, you can remove it by setting: Options-->Security-->Remove Personal information from file properties on save. User name in Comment wil change to "Author:"