- #Change the comments author name in word 2016 for mac how to#
- #Change the comments author name in word 2016 for mac code#
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()
#Change the comments author name in word 2016 for mac 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.
#Change the comments author name in word 2016 for mac how to#
How to change all comments’ author name in Excel?
0 kommentar(er)
