Can't Edit my Excel Comments

Brett0769

New Member

Join Date: Apr 2012

Posts: 1

26th Apr 2012

I ran into this problem with a recent upgrade to Excel 2010. This is the macro I put in place to correct the problem. It works on the currently selected range. The downside is that you lose the bold on the commenter's name.

Public Sub ReplaceComments()
Dim c As Object
Dim strComment As String
For Each c in Selection.Cells
If Not c.Comment Is Nothing
strComment = c.Comment.Text
c.Comment.Delete
c.AddComment(strComment)
End If
strComment = ""
Next c
Set c = Nothing
End Sub

Page 2 of 2

« Re: Macro to send an email automatically | Re: UpperCase changes date format »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
excel 2000 how to format the comments font all comments	Delquestion	Microsoft Excel Misc	1	8th Oct 2009 02:19 PM
Merge Comments / Wrap comments / Concatonate Comments	Gary	Microsoft Access Queries	4	15th Apr 2009 03:46 PM
in excel useing comments how do you add clip art to comments?	=?Utf-8?B?ZGhvdXNl?=	Microsoft Excel New Users	2	18th Jul 2007 08:14 AM
Change Word Edit>SelectAll to Edit>Select>SubMenu like Edit>Clear>	=?Utf-8?B?TW9udGUgSGFucmFoYW4=?=	Microsoft Word New Users	9	11th Jun 2006 07:52 PM
Edit Excel Comments	=?Utf-8?B?UGlkZGlsaW4=?=	Microsoft Excel Misc	3	19th May 2004 08:25 PM