Change background & foreground colors in Comment box

[Doug]

How can I change the background and foreground colors in a comment box?
I have changed the Vista theme and comments are appearing as white on white.

Right-clicking a comment box and choosing Format Comment allows changing the
font colour but only for that one comment. I need to change all comments.

 

[Dave Peterson]

You could use a macro that just loops through the comments.

Debra Dalgleish shares some code that does that:
http://www.contextures.com/xlcomments03.html#Format

But you'll have to modify the code to change the colors.

I'd record a macro that did the work and then try to modify her code with the
changes.

If you have trouble, paste your recorded code in your response.

If you're new to macros:

Debra Dalgleish has some notes how to implement macros here:
http://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm

(General, Regular and Standard modules all describe the same thing.)