VBA workaround to set workbook color theme

[Sintek]

Hey guys

Has anyone got a workaround to set the default theme in excel
I need to set theme to "Metro"...Any ideas

Scenario as follows...
I have copied sheet to newbook...and set colors

Please Login or Register  to view this content.

Even tried setting the range and changing the color index, however as the default theme is different, the color index is different...

[xlnitwit]

Hi,

Can you clarify what theme you are trying to set- do you want to apply wb's them to nbk as a whole, or are you just trying to update colours on the new copied sheet, or something else?

[Sintek]

Not to worry...managed to replicate the colors via RGB setting
Edit
@ xlnitwit....
wanted to have the interior colors the same as the source workbook....the nbk color scheme was "Office"....source wb was "Metro"

[Marc L]

Hi !

Workaround from source workbook : Save As …

[Sintek]

@ Marc L

Only want one sheet of 50 to be exported...have been googling and so far no results...Anyway, will carry on and advise if a workaround comes up....