If you just run that in a simple macro within the workbook, doesn't saving
it preserve those colours for you?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"samearle" wrote in message
ups.com...
How do I add the below???

I opened a new excel doc, went to tools - visuall basic editor. Then
added the following to module1:

ThisWorkbook.Colors(1) = RGB(100, 200, 200)
ThisWorkbook.Colors(2) = RGB(100, 200, 200)
ThisWorkbook.Colors(55) = RGB(100, 200, 200)
ThisWorkbook.Colors(56) = RGB(100, 200, 200)

basically, what I am trying to do is change collors to custom collors
every time the document opens. TO eliminate the document reverting to
standard colors or custom set on that machine.

Thanks,

Sam