Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change background & foreground colors in Comment box
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. -- Doug |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change background & foreground colors in Comment box
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 he 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.) Doug wrote: 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. -- Doug -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lost highlighting and font colors; background colors on web pages | Excel Discussion (Misc queries) | |||
Button or key to conditionally change text foreground color? | New Users to Excel | |||
change comment color in Excel when background is the same | Excel Discussion (Misc queries) | |||
background-foreground color | Charts and Charting in Excel | |||
How do I change background colors between secondary y axis lines? | Charts and Charting in Excel |