Color Scheme Strikes Again!

[Guest]

I am working with a presentation that has Slide master shapes that are
intended to have red text along with a table with (imported through code from
Access) hyperlinks. Now, they hyperlinks are colored red (because for
whatever reason, Microsoft decided it would be a smoking hot idea to combine
the Accent and Hyperlink color values into one unwieldy selection) which
makes them look a little odd.

Additionally at the top of the table (also created by code) that the
hyperlinks are in, I have a merged cell that I want red. When I set the
background color on it via

ActivePresentation.Slides(3).Shapes("ProdTable").(Some objects/properties
omitted).BackColor.RGB = RGB(Red:=255, _
Green:= 0, _
Blue:=0)

it leaves the cell blue because that is the color set for Fill effects
(which in turn colorfills the charts that are dispersed throughout the rest
of the presentation).

What I want to do:

1. Force the Hyperlinks to be blue while still having the Head/Footer text
stay red. 2. Force the top cell of the table to have a red background.

I miss Publisher. When you tell it to do something, it damn well does it.
None of this color scheme stuff. Anyone have a way to either ignore the
color scheme altogether or just force shapes to be a specified color despite
the scheme?

Cory

 

[Steve Rindsberg]

See below:

I am working with a presentation that has Slide master shapes that are
intended to have red text along with a table with (imported through code from
Access) hyperlinks. Now, they hyperlinks are colored red (because for
whatever reason, Microsoft decided it would be a smoking hot idea to combine
the Accent and Hyperlink color values into one unwieldy selection) which
makes them look a little odd.

Additionally at the top of the table (also created by code) that the
hyperlinks are in, I have a merged cell that I want red. When I set the
background color on it via

ActivePresentation.Slides(3).Shapes("ProdTable").(Some objects/properties
omitted).BackColor.RGB = RGB(Red:=255, _
Green:= 0, _
Blue:=0)

it leaves the cell blue because that is the color set for Fill effects
(which in turn colorfills the charts that are dispersed throughout the rest
of the presentation).

What I want to do:

1. Force the Hyperlinks to be blue while still having the Head/Footer text
stay red. 2. Force the top cell of the table to have a red background.

I miss Publisher. When you tell it to do something, it damn well does it.
None of this color scheme stuff. Anyone have a way to either ignore the
color scheme altogether or just force shapes to be a specified color despite
the scheme?

There are some very handy uses for the color scheme. Personally I'm waiting for
PPT to catch up to where Freelance was 15 years ago with them. Some day ...

But for now, any shape can have a fill color that's either a scheme color or an
RGB color; not both, and assigning one overrides the other. IOW, it'll do what
you want it to but you have to ask nicely.

ActivePresentation.Slides(3).Shapes("ProdTable").(Some objects/properties
omitted).BackColor.RGB = RGB(Red:=255, _
Green:= 0, _
Blue:=0)

Assuming the omitted objects/properties are correct you probably just need to
use .ForeColor.RGB instead of .BackColor

 

[Guest]

Yeah I tried that. Instead of turning it Red, it turned it purple instead.
:-/ The color scheme wants it to be blue, I set the BackColor to red and it
stays blue, I set the ForeColor to red and it makes it purple. I think it is
playing with me. The only thing that keeps me from hurting the machine is
that the company would make me buy it... and I would likely have to take the
workplace violence training more than semi-annually.

I managed to make a scheme that would do after writing the first post. It
had not dawned on me that the first row of colors in the pallets represented
the Scheme colors. Once I found that out, I was able to change some shapes
color scheme assignments to suit it better.

Thanks for the help. More to follow probably. Powerpoint does not seem to
have a very straightforward implementation of VBA. The recorder only records
about half of the things you do.

Cory

 

[Steve Rindsberg]

Yeah I tried that. Instead of turning it Red, it turned it purple instead.
:-/ The color scheme wants it to be blue, I set the BackColor to red and it
stays blue, I set the ForeColor to red and it makes it purple. I think it is
playing with me. The only thing that keeps me from hurting the machine is
that the company would make me buy it... and I would likely have to take the
workplace violence training more than semi-annually.

Sounds as though there might be some transparency involved as well as color.
Trust in one thing: you do NOT have to use scheme colors if you don't want to.

Thanks for the help. More to follow probably. Powerpoint does not seem to
have a very straightforward implementation of VBA. The recorder only records
about half of the things you do.

And half of that is not really usable code. It's not bad for sorting out one liners
but beyond that ... well. No matter. It's gone in 2007 anyhow.