arcadekrot.blogg.se - How to change author name in word 365

#How to change author name in word 365 how to#
#How to change author name in word 365 install#
#How to change author name in word 365 code#
#How to change author name in word 365 trial#

If you want to have a free trial ( 30-day) of this utility, please click to download it, and then go to apply the operation according above steps.Ĭhange all comments’ author name with Kutools for Excel

(4) Click the Close button to close the dialog box.

(3) In the popping up dialog box, click the OK button.

(1) Enter the new author name of comments into the User Name box, and then choose the Add user name to comments option.

Then add new author name to all comments in specified scope.

(4) In the popping up dialog box, click the OK button.

(2) Choose the Remove user name from comments option.

For changing author names in the whole workbook, please select All Sheets option.

(1) In the Scope drop-down list, if you just want to change author names in current sheet, please select Active sheet option.

In the Remove/Add User Name in Comment dialog box, you need to configure as follow: Firstly, remove author name from all comments in specified scope. Shift to the worksheet you want to change all comments' author name inside, then click Kutools > More > Remove/Add User Name in Comment.

#How to change author name in word 365 install#

With this utility, you can easily change the author name of all existing comments to the new one you need not only in active sheet, but also in the whole workbook.īefore applying Kutools for Excel, please download and install it firstly.ġ. Note: This method won't work to the new comments you insert.īesides the above two methods, here I recommend you the Remove/Add User Name in Comment utility of Kutools for Excel. Now all author names of the existing comments are changed to the new name in the whole workbook immediately. Then another KutoolsforExcel dialog box pops up, please type the new comment's author name you need into the textbox, and then click the OK button. Press the F5 key to run the code, then a KutoolsforExcel dialog box popping up with the old comment author name displaying in the textbox, please click the OK button. XComment.Text (Replace(xComment.Text, oldName, newName))Ģ. NewName = InputBox("New Name", xTitleId, "")įor Each xWs In OldName = InputBox("Old Name", xTitleId, Application.UserName)

VBA code: Change the author name of all existing comments in the whole workbook Sub ChangeCommentName()

#How to change author name in word 365 code#

And in the Microsoft Visual Basic for applications window, click Insert > Module, then copy and paste the following code into the module window:

Please press Alt + F11 keys at the same time to open the Microsoft Visual Basic for Applications.

If you want to change the author name of all exiting comments in the whole workbook, the below VBA code will help you:ġ. Download and try it now! ( 30-day free trail) With the Remove/Add User Name in Comment utility of Kutools for Excel, you can quickly change the author name of all existing comments as the below demo shown. Quickly change the author name of all existing comments in Excel However, the author name of the old comments still kept the old one. See screenshot:įorm now on, when you inserting new comments into your worksheet, the author name will be the new one as you specified above. In the Excel Options dialog box, click General in the left bar, then scroll to the Personalize your copy of Microsoft Office section in the right pane, then replace the old User name with the new one you need. Click File > Options in Excel 2010/2013/2016, or you can click the Office button > Excel Options > Popular in Excel 2007.Ģ. You can change the Excel user name in order to change the auther name of all new comments you will insert.ġ. Quickly change the author name of all existing comments in active or all sheets with Kutools for Excel How can you do? You can change the name of comment author in Excel as the following methods.Ĭhange the default author name of all new comments with configuring Excel OptionsĬhange the author name of all existing comments in the whole workbook with VBA code Sometimes, you may want to change the name of comment author. When you insert the comments into a worksheet, the name of the comment author is automatically inserted into the comment followed by a colon.

#How to change author name in word 365 how to#

How to change all comments’ author name in Excel?