Removing names from comments

Gillian · #1 12-22-2015, 02:39 AM

I need to keep the comments in a document but remove the name of the commenter so I can pass the file on to a third party who is not allowed to know the name of the person who posted the comments. I've removed the person's name from the document properties but it still appears in each comment.

macropod · #2 12-22-2015, 03:33 AM

You could use a macro like:

Code:

Sub Demo()
Dim Cmnt As Comment
For Each Cmnt In ActiveDocument.Comments
  Cmnt.Author = ""
Next
End Sub

For PC macro installation & usage instructions, see: http://www.gmayor.com/installing_macro.htm

Do note this will still leave the comment date/time stamp, which can't be removed. The only way around that would be to replace all the comments so they get the current date & time.

Gillian · #3 12-22-2015, 11:52 PM

Actually it's really easy. I don't know why I didn't try this before, but you just go to Prepare for Sharing, Inspect document, and click Remove All Document Properties and Personal Information. The comments are still there but are labelled 'A1' etc.
Sorry to have bothered you - but maybe someone will find this useful one day.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Removing duplicates	saurabhlotankar	Excel Programming	14	05-26-2015 10:13 AM
matching names in column A with names in column C	bob999999	Excel	1	04-28-2013 11:21 AM
How to enter names in Resource Pool/names	pstein	Project	1	03-26-2012 07:37 AM
How to Get Rid of Comments?	freschij	Outlook	0	08-02-2011 12:47 PM
Comments	davidcs	Word	0	01-05-2010 12:55 AM