+ Reply to Thread
Results 1 to 3 of 3

Modify Macro to show company's color palette

  1. #1
    Registered User
    Join Date
    12-17-2013
    Location
    Greater NYC Area
    MS-Off Ver
    Excel 2010
    Posts
    84

    Modify Macro to show company's color palette

    Greetings,

    My company's branding standards have ten specific colors they want us to use on their marketing materials. I played around with changing the theme colors in excel, but I found the side effects of losing all of Excel's default colors to be a nuisance.

    I found a terrific macro online which provides the exact functionality I'm interested in. It builds an icon or your ribbon or quick access toolbar which allows you to quickly pick a predefined color and apply it to the selected range. Here is the link to it:
    http://spreadsheetpage.com/index.php...er_dialog_box/

    However I cannot figure out for the life of me how to change the predefined colors from this macro. I would like to replace the predefined colors with my company's colors and apply them to the form for my easy access. How would I go about doing this?

    Thanks

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    16,941

    Re: Modify Macro to show company's color palette

    The code sets the colors to be the colors in the active workbook's color palette. This code is found in Module1 of the download file. To change the colors, you will have to write code to set the desired RGB color each of the buttons.

    Original code:
    Please Login or Register  to view this content.
    Modify it to assign a specific color to each button:
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    12-17-2013
    Location
    Greater NYC Area
    MS-Off Ver
    Excel 2010
    Posts
    84

    Re: Modify Macro to show company's color palette

    Perfect! thanks so much Jeff, this will save me a good chunk of time!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Can I modify Excel 2003 color palette to accept Pantone colors?
    By snowmobile in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 04:05 PM
  2. Can I modify Excel 2003 color palette to accept Pantone colors?
    By snowmobile in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 PM
  3. [SOLVED] Can I modify Excel 2003 color palette to accept Pantone colors?
    By Chip Pearson in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 09:05 AM
  4. Can I modify Excel 2003 color palette to accept Pantone colors?
    By snowmobile in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  5. Can I modify Excel 2003 color palette to accept Pantone colors?
    By snowmobile in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1