rajkumar
03-28-2010, 12:49 PM
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
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