Remove Your Name From An Excel Comment

BY STANLEY ZAROWIN

REMOVE YOUR NAME FROM AN EXCEL COMMENT
Every time I add a comment in an Excel cell, it automatically inserts my name. Since I’m the only one using this computer and I don’t send my worksheets to anyone else, it’s a nuisance. How can I stop Excel from doing that?

This is another example of Excel’s second-guessing the user—and once again guessing wrong. Short of using a macro that you would have to trigger for each comment, I know of no simple way to stop the insertion. What I do is change the automatic full-name label to something innocuous—such as Note, a period or an asterisk (see screenshots below).

To do that, click on Tools, Options and the General tab. Then, in the box next to User name, delete your name and add the label of your choice. When you create the comment box, the colon will remain.

If you choose to use a macro instead, here’s what you do: Press Alt+F11 to start the Visual Basic Editor. Click on Module on the Insert menu and type the following macro code in a new module:

Sub New_Comment()

ActiveCell.AddComment ("")

ActiveCell.Comment.Visible = True

End Sub

Then, click on File and Close and Return to Microsoft Excel. To run the macro, select a cell in which you want the no-name comment to appear and click on Tools, point to Macro and click on Macros. Select the New_Comment macro and click on Run, which commands Excel to insert a new no-name comment for that cell. Finally, click in the text area of the comment and type away—anonymously.

If you want to add some fancy touches to your comments—such as changing the font style—consider this macro instead:

Sub Fancy_Comment()

'Create the comment.

ActiveCell.AddComment ("")

ActiveCell.Comment.Visible = True

ActiveCell.Comment.Shape.Select

With Selection

'Set the AutoShape.

.ShapeRange.AutoShapeType = _

msoShapeExplosion2

'Set background color.

.ShapeRange.Fill.PresetGradient _

msoGradientHorizontal, 1, _

msoGradientHorizon

'Set the font.

.Font.Name = "Arial"

.Font.FontStyle = "Bold Italic"

End With

End Sub

The good news about these methods is they provide a choice of whether to include your name—or anyone else’s for that matter—in the comment.

If anybody has a better solution, please send it to me and I will post it in a future column.

SPONSORED REPORT

8 accounting and auditing issues you can’t afford to ignore

Download this sponsored report for an overview of some of the most important developments accountants and auditors are facing today.

DOWNLOAD

Filing season quick guide — Tax year 2014

Tax season started Jan. 20. Download our “quick guide,” a printable card that contains dollar thresholds, tax tables, standard amounts, credits, and deductions to keep at your fingertips during tax season.

TAX NEWS

Expired tax provisions extended for 2014

President Barack Obama signed legislation that retroactively extended more than 50 expired tax provisions for 2014, allowing taxpayers to take advantage of a host of tax incentives during this filing season.