Resetting Color Pallette

[rajkumar]

Hi Experts,

I need help in resetting Excel's Color Palette to default thru VBA.

We use Discoverer Plus ( Oracle BI ) reports which has workbook open event macros which formats the worksheets colors and changes the excel's color pallette according to Discoverer Reports.

Every time i had to close and reopen Excel to get the default color palette back in action. Tried to reset by selecting each color in Tools> Options >Color > Reset Button. Did'nt work as desired.

If anyone help by providing me a code that can reset the Color palette to default Excel's color palette, it will be great.

Thanks in advance

Raj :help

[Bob Phillips]

ActiveWorkbook.ResetColors

[rajkumar]

Hi Xld,

Seems not working. I am posting a sample of my report herewith for testing.
Please help.
Thanks
Raj

[SamT]

Works for me.
Run the Macro "Reset_Colors" in the "ThisWorkbook" Code Page.