1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Colour Palettes

Discussion in 'Microsoft Office' started by Graham, Jan 25, 2010.

  1. Graham

    Graham Flightless Bird

    Hi
    I have received a Powerpoint 2003 slide deck from a client that contains a
    colour palette they would like me to use. I would like to be able to easily
    replicate this colour palette in either Excel 2003 or Excel 2007. Is there a
    way of transferring a colour palette from Powerpoint to Excel?
    Thanks
    Graham
     
  2. Steve Rindsberg

    Steve Rindsberg Flightless Bird

    In article <36EA8DB0-DBC1-4C67-ABDC-E132E5282F64@microsoft.com>, Graham wrote:
    > Hi
    > I have received a Powerpoint 2003 slide deck from a client that contains a
    > colour palette they would like me to use. I would like to be able to easily
    > replicate this colour palette in either Excel 2003 or Excel 2007. Is there a
    > way of transferring a colour palette from Powerpoint to Excel?
    > Thanks
    > Graham


    PPT doesn't have palettes; 2003 and earlier use Schemes, which contain only 8
    colors. Choose Format, Slide Design. Click "Color schemes" in the panel that
    opens on the right then "Edit color schemes" to open the scheme editor for the
    current slide. Doubleclick any of the scheme colors and you'll be able to get
    the RGB values for the color on the Custom Colors tab.

    This snippet will give you the Long values representing the RGB color of each
    scheme color:

    Sub thingie()
    Dim x As Long
    With ActiveWindow.Selection.SlideRange(1)
    For x = 1 To .ColorScheme.Count
    Debug.Print .ColorScheme.Colors(x).RGB
    Next
    End With
    End Sub
     

Share This Page