Change format of all comments in an Excel worksheet
 

I'd like to change the formatting of all comments in an Excel worksheet. The
help menu only tells how to format individual comments. Does anyone know a
simple way to do this? (Using format painter might be an option if there are
only a few comments, but I don't think it would work very well when more than
100 cells have comments.)
Thanks for any help on this.

Change format of all comments in an Excel worksheet
 

Depending on what you're doing, you may be able to loop through each comment and
change the formats.

I'd record a macro when I did one alteration, then try to generalize it to do
all the comments.

Debra Dalgleish has lots of sample code for working with comments:
http://contextures.com/xlcomments03.html

Eric Armstrong wrote:

I'd like to change the formatting of all comments in an Excel worksheet. The
help menu only tells how to format individual comments. Does anyone know a
simple way to do this? (Using format painter might be an option if there are
only a few comments, but I don't think it would work very well when more than
100 cells have comments.)
Thanks for any help on this.

--

Dave Peterson