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?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Samuel Thomsen

    Color Tabs

    Samuel Thomsen, Jul 24, 2003, in forum: Microsoft Excel Discussion
    Replies:
    1
    Views:
    569
    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:
    648
    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:
    444
    David McRitchie
    Feb 6, 2004
  4. Guest
    Replies:
    2
    Views:
    1,599
    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:
    340
    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:
    859
    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:
    437
    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,297
    narke
    May 31, 2010
Loading...