#1
|
|||
|
|||
VBA/Macro to change one colour in chart to another
Dear all,
I have about 70 charts in an Excel spreadsheet that contain a line filled with RGB 55,133,70. I want to change all occurrences of this colour to RGB 51,51,51. Does anybody know how to write this as a Macro for all graphs in the sheet? Many thanks! |
#2
|
||||
|
||||
It would be better to post this question in the VBA forum
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Microsoft Office 2010, Can't change fonts colour | Myayadana | Office | 0 | 08-22-2013 11:26 PM |
VBA to immediately change the colour of a cell depending on the code placed in anothe | Phil Payne | Excel Programming | 2 | 07-27-2013 11:04 PM |
Change font colour when tasks are completed | meileetan | Project | 3 | 09-12-2012 07:09 AM |
Change Colour Theme in Word with VBA | Davidoff78 | Word VBA | 1 | 06-28-2012 05:23 PM |
CHange colour of footer if a cell changes to red | OTPM | Excel | 0 | 05-26-2011 07:15 AM |