Cheers,

What i'm trying to do is to get the colour scheme defined in another book.
Tools > options > Color > copy colors from

Alternatively i would like to make a code that redefines the color scheme in excel

Is this better?