Pallet color changer

[Fan924]

I would like to create a worksheet that reads a workbooks color
pallet, make changes, save the new colors to the color pallet using
VBA. How do you save changes to the pallet?
Excel 97.

 

[Dave Peterson]

The colors are saved on a workbook by workbook level.

You can record a macro when you change the colors using the tools|options|color
tab.

David McRitchie has some notes here:
http://mvps.org/dmcritchie/excel/colors.htm

 

[Fan924]

You can record a macro when you change the colors using the tools|options|color tab.

Nice! Thanks again. :]