• Announcements

    • xper

      MSFN Sponsorship and AdBlockers!   07/10/2016

      Dear members, MSFN is made available via subscriptions, donations and advertising revenue. The use of ad-blocking software hurts the site. Please disable ad-blocking software or set an exception for MSFN. Alternatively, become a site sponsor and ads will be disabled automatically and by subscribing you get other sponsor benefits.
Sign in to follow this  
Followers 0
novicee

Applying a name change to existing comments in an Excel 2007 spreadshe

4 posts in this topic

Applying a name change to existing comments in an Excel 2007 spreadsheet

 

I have inserted comments into cells of an Excel 2007 spreadsheet using "right click mouse > insert comment ". When I hover the cursor over a cell with a comment, a message appears in the "task bar" (not sure this is the correct name for it) at the bottom of the page. The message says, for example,  "Cell E7 commented by JD". I want to expand the initials "JD" to a name and apply the change to all the comments I have already entered.

 

I selected the options, "round MS button at top left of page > Excel Options > Popular > User Name ". The last option is under the heading " Personalize your copy of Microsoft Office".  I changed "JD" to "John". This has become the name that new comments are attributed to but the old comments are still attributed to "JD".

 

Is there a way I can apply the name change to comments entered before the change was made?

 

I would be grateful for any help on this.

0

Share this post


Link to post
Share on other sites

The name doesn't even seem to be a special field in the comment, it is just inserted automatically at the beginning of the text when the comment is 1st created. So I guess no, you'll have to manually edit all comments.

0

Share this post


Link to post
Share on other sites

No, it is not a "special field" (and it is right :yes: that is not "dynamic" as, if you open the same worksheet on another PC/another instance of Excel with a different user name all comments would change accordingly :w00t:), it is a sort of "quick template".

 

But still, you can use VBA to change the values in the comments:

http://www.extendoffice.com/documents/excel/678-excel-change-comment-author.html

 

Please understand that this is basically a "replace" function, so hopefully in your case you won't have anything except you initials JD actually containing "JD" or "jd".

 

By default what you should actually have in the comment is "JD:", I would add the ":" colon sign in both the "search" and "replace" fields.

Of course test on a copy of the file, first. ;)

 

jaclaz

0

Share this post


Link to post
Share on other sites

jaclaz, thanks very much for the info.

0

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0

  • Recently Browsing   0 members

    No registered users viewing this page.