Chris Macro
Well-known Member
- Joined
- Nov 2, 2011
- Messages
- 1,345
- Office Version
- 365
- Platform
- Windows
I am trying to figure out how to retrieve the theme color property from a bar chart. If I select a Bar Chart that has a fill color associated with a theme color and execute the following code:
it returns a value of 0 (aka msoNotThemeColor). Through further testing, it appears I can set theme colors but cannot determine if a theme color is currently applied to a chart. Any ideas on why this is occurring and how to get around it?
Code:
Selection.Format.Fill.ForeColor.ObjectThemeColor
it returns a value of 0 (aka msoNotThemeColor). Through further testing, it appears I can set theme colors but cannot determine if a theme color is currently applied to a chart. Any ideas on why this is occurring and how to get around it?