Change "Colors" Option through VBA

[jomaor1]

Hello,

I'm having some trouble finding a VBA Code that changes the Color Theme of Excel.

i.e. "Page Layout" > "Colors" > "Office 2007-2010"

I just want a button that changes to this or to another color from the List.

0CE5AECA-AA06-42A1-85D3-54FAF0D6F023.png.jpg

Thank you in advance!

[WideBoyDixon]

Please Login or Register  to view this content.

e.g., on my PC running Office 365 32-bit:

Please Login or Register  to view this content.

WBD

[jomaor1]

Hi WBD,

Is possible to have another code that isn't attached to the location?
Because I want to share my workbook with the code, and the location will be different for each user...

Thanks

[WideBoyDixon]

Then you'll need to have a "well known" location for the XML file (network drive for example) and load it from there.

WBD