Pallet color changer

Discussion in 'Microsoft Excel Discussion' started by Fan924, Aug 21, 2009.

  1. Fan924

    Fan924 Guest

    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.
     
    Fan924, Aug 21, 2009
    #1
    1. Advertisements

  2. 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 wrote:
    >
    > 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
     
    Dave Peterson, Aug 21, 2009
    #2
    1. Advertisements

  3. Fan924

    Fan924 Guest


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


    Nice! Thanks again. :]
     
    Fan924, Aug 21, 2009
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. X-Men

    Color Index and RGB Color

    X-Men, Feb 5, 2004, in forum: Microsoft Excel Discussion
    Replies:
    1
    Views:
    284
    David McRitchie
    Feb 6, 2004
  2. Guest
    Replies:
    2
    Views:
    1,342
    Guest
    Jul 5, 2007
  3. Creamegg

    Color Chart Columns to Color Specified by a Cell Value

    Creamegg, Jul 23, 2008, in forum: Microsoft Excel Discussion
    Replies:
    0
    Views:
    212
    Creamegg
    Jul 23, 2008
  4. Carl Willems

    Collor pallet changes unwanted after SAP export

    Carl Willems, Aug 11, 2008, in forum: Microsoft Excel Discussion
    Replies:
    2
    Views:
    499
    Karl M Pierz
    Oct 9, 2008
  5. moonhkt

    Excel color pull down does not have some stanard color

    moonhkt, Feb 11, 2010, in forum: Microsoft Excel Discussion
    Replies:
    2
    Views:
    343
    moonhkt
    Feb 12, 2010
Loading...

Share This Page