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. Samuel Thomsen

    Color Tabs

    Samuel Thomsen, Jul 24, 2003, in forum: Microsoft Excel Discussion
    Replies:
    1
    Views:
    537
    Andy Brown
    Jul 24, 2003
  2. Bernie Deitrick

    Re: Identify color in shape object.

    Bernie Deitrick, Jul 29, 2003, in forum: Microsoft Excel Discussion
    Replies:
    1
    Views:
    622
    David McRitchie
    Jul 29, 2003
  3. X-Men

    Color Index and RGB Color

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

    Color Chart Columns to Color Specified by a Cell Value

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

    Collor pallet changes unwanted after SAP export

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

    Excel color pull down does not have some stanard color

    moonhkt, Feb 11, 2010, in forum: Microsoft Excel Discussion
    Replies:
    2
    Views:
    409
    moonhkt
    Feb 12, 2010
  8. narke

    How to make font color oppose to cell interior color

    narke, May 25, 2010, in forum: Microsoft Excel Discussion
    Replies:
    4
    Views:
    1,232
    narke
    May 31, 2010
Loading...