How do I change user name in comment cells?

[ted]

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]

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.

 

[John]

Hi Ted
If you are using Xcel 2003, you can
Go to > Tools>Option>General> User name, and leave blank or change the name.
HTH
John