We currently have an add-in for Excel Xp which changes the default excel
color palette so that it displays our companies corporate color scheme. We
are wanting to use this in Excel 2007 as well but cannot get it to work.
Included is some of the code used for Excel XP

Sub companyPalette()
On Error Resume Next
'Modify the first row to compnay Primary color Palette
ActiveWorkbook.Colors(11) = RGB(160, 0, 80)
ActiveWorkbook.Colors(55) = RGB(225, 110, 0)
ActiveWorkbook.Colors(52) = RGB(235, 175, 0)
ActiveWorkbook.Colors(51) = RGB(180, 190, 0)
ActiveWorkbook.Colors(49) = RGB(0, 180, 175)
ActiveWorkbook.Colors(53) = RGB(230, 80, 50)
ActiveWorkbook.Colors(1) = RGB(0, 0, 0)
ActiveWorkbook.Colors(56) = RGB(153, 153, 153)
ActiveWorkbook.Colors(9) = RGB(255, 255, 255)

Can anyone advise how to amend this code to do the same in excel 2007, i
know Excel 2007 uses a different color palette to excel xp