Thread: How to change the default interior color palette index in Excel 2003
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] tenten0925@gmail.com is offline
external usenet poster
  
Posts: 1
Default How to change the default interior color palette index in Excel 2003
I want to use the command

Cells(i, j).Interior.ColorIndex = 50

to fill the cell with color I want.

In Excel, it has its default index palette for Interior Color.

How can I customized its index or even change the color in each index
number?

Coz the default index palette doesn't match with the palette under
Tools --- Options ---- Color

Any one can help on this???

MICTEN

Reply With QuoteReply With Quote