XL98: Sample Macro to Remove User Name from Comment (184098)
The information in this article applies to:
- Microsoft Excel 98 Macintosh Edition
This article was previously published under Q184098 SUMMARY
By default, the text of a cell comment contains the user name in the first
line of the comment. There is no built-in feature that automatically
prevents the user name from being inserted in the comment text. However,
you can use a Visual Basic for Applications macro to insert a blank
comment. This article contains a macro example that inserts a blank comment
in the active cell.
NOTE: The user name that is displayed in the comment is the same name that
appears in the User Name box when you click Preferences on the Tools menu,
and then click the General tab.
REFERENCES
For more information about cell comments, click Contents And Index on the
Help menu (or on the Balloon Help menu if you are using a version of the
Macintosh operating system earlier than 8.0), click the Index button in
Microsoft Excel Help, type the following text
comments, overview
and then click Show Topics. Select the "About adding comments and
highlighting changes in a workbook" topic, and click Go To. If you are
unable to find the information you need, ask the Office Assistant.
Modification Type: | Major | Last Reviewed: | 6/23/2005 |
---|
Keywords: | kbdtacode kbhowto kbProgramming KB184098 |
---|
|