ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I change user name in comment cells? (https://www.excelbanter.com/excel-discussion-misc-queries/209841-how-do-i-change-user-name-comment-cells.html)

Ted

How do I change user name in comment cells?
 
On older spreadsheets there is a user name from the original creator of the
spreadsheet. I want to revise the spreadsheet and change the user name in
the comment box to another name. How do I do it in Vista. Office
Professional?

Sheeloo[_3_]

How do I change user name in comment cells?
 
You will have to use a macro...
See http://www.contextures.com/xlcomments03.html#OldName for a very nice
solution

Parent of the above http://www.contextures.com/xlcomments03.html will tell
you all about comments.

"ted" wrote:

On older spreadsheets there is a user name from the original creator of the
spreadsheet. I want to revise the spreadsheet and change the user name in
the comment box to another name. How do I do it in Vista. Office
Professional?


John[_22_]

How do I change user name in comment cells?
 
Hi Ted
If you are using Xcel 2003, you can
Go to ToolsOptionGeneral User name, and leave blank or change the name.
HTH
John
"ted" wrote in message
...
On older spreadsheets there is a user name from the original creator of
the
spreadsheet. I want to revise the spreadsheet and change the user name in
the comment box to another name. How do I do it in Vista. Office
Professional?




All times are GMT +1. The time now is 08:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com