How to set the color theme through VBA

[Rajneesh Rawat]

Hi All,

Can anyone suggest how to set the colors theme- Office 2007-2010(Menu-> Page Layout->Colors->Office 2007-2010).

I want to do this through VBA.

thanks
Rajneesh

 

[Domenic]

Try recording a macro while setting the color theme. When I recorded the macro, I got the following code..

    ActiveWorkbook.Theme.ThemeColorScheme.Load _
        "C:\Program Files (x86)\Microsoft Office\Root\Document Themes 16\Theme Colors\Office 2007 - 2010.xml"

Hope this helps!

 

[Rajneesh Rawat]

Hi,

Thanks for ur response. I tried recording and it is showing as:

    ActiveWorkbook.Theme.ThemeColorScheme.Load ( _
        "C:\Program Files\Microsoft Office\Document Themes 16\Theme Colors\Office 2007 - 2010.xml" )

Here ,Path may be change on another system. But this is helpfull to me...thanks again

 

[Domenic]

You're very welcome!

Cheers!