Jump to content

Welcome to MSFN Forum
Register now to gain access to all of our features. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more. This message will be removed once you have signed in.
Login to Account Create an Account



Photo

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

- - - - - Excel 2007 Comments

  • Please log in to reply
3 replies to this topic

#1
novicee

novicee

    Newbie

  • Member
  • 16 posts
  • Joined 05-May 10
  • OS:Windows 7 x86
  • Country: Country Flag

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.


"Everything should be made as simple as possible but not simpler" - Einstein


How to remove advertisement from MSFN

#2
Ponch

Ponch

    MSFN Junkie

  • Patrons
  • 3,307 posts
  • Joined 23-November 05
  • OS:none specified
  • Country: Country Flag

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.



#3
jaclaz

jaclaz

    The Finder

  • Developer
  • 14,675 posts
  • Joined 23-July 04
  • OS:none specified
  • Country: Country Flag

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.extendoff...ent-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



#4
novicee

novicee

    Newbie

  • Member
  • 16 posts
  • Joined 05-May 10
  • OS:Windows 7 x86
  • Country: Country Flag

jaclaz, thanks very much for the info.


"Everything should be made as simple as possible but not simpler" - Einstein




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users