change default color theme so it is the same on all new workbooks

[blewth]

Hi

I want to change the default color theme so that it is the same on all new workbooks I open without having to manually change it...

I have my color theme saved. I just want to know how to set it as the default for all new workbooks automatically

Thanks

 

[RedBeard]

Have a look here: https://support.office.com/en-us/ar...or-Excel-c846f997-968e-4daa-b2d4-42bd2afef904

 

[blewth]

What if your version of excel has no "design" tab as mentioned in that article...

 

[blewth]

I have solved this. thanks everyone