New charts take on ppt font / PPTColorsForNewGraphs

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

StephanM - 30 Mar 2007 22:10 GMT

In Tools - Options there is an option "New charts take on ppt font". (This
Option is stored with the reg key "PPTColorsForNewGraphs".)
Does anybody know how to set the option with a vba macro?

Thx, Stephan

Reply to this Message

Steve Rindsberg - 31 Mar 2007 01:09 GMT

> In Tools - Options there is an option "New charts take on ppt font". (This
> Option is stored with the reg key "PPTColorsForNewGraphs".)
> Does anybody know how to set the option with a vba macro?

Most of the stuff in Tools, Options isn't exposed to VBA; generally you need to
use SendKeys to feed PPT the proper keystrokes to do what you're after.

Yes. It *is* ugly as sin.

Externally you can probably make a registry setting to alter this, but only
when PPT isn't running.

-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================

Reply to this Message

StephanM - 31 Mar 2007 07:18 GMT

Hello Steve,

thank you for the answer.
I also thought about using sendkeys - but with sendkeys the next problems
comes up.
PPT 2003 remembers the Tab of the options command the user last used (sorry
for my bad english).
I cannot jump to the german tab "Bearbeiten" (Edit, I think).
And the second problem: How can I switch off an option? Sending the key does
toggle the option on an off.

Stephan

> > In Tools - Options there is an option "New charts take on ppt font". (This
> > Option is stored with the reg key "PPTColorsForNewGraphs".)
[quoted text clipped - 13 lines]
> PPTools: www.pptools.com
> ================================================

Reply to this Message

Steve Rindsberg - 31 Mar 2007 20:43 GMT

> Hello Steve,
>
[quoted text clipped - 3 lines]
> PPT 2003 remembers the Tab of the options command the user last used (sorry
> for my bad english).

No problem. I understood what you meant immediately.

[HEY SHYAM didn't you have a general solution for this problem?]

> I cannot jump to the german tab "Bearbeiten" (Edit, I think).
> And the second problem: How can I switch off an option? Sending the key does
> toggle the option on an off.

You'd send the correct number of TABs (with SendKeys) to move the focus to the
correct option, then send a SPACE to toggle it.

I suspect you'd have to read the registry first to learn the current state of the
option (to decide whether you need to toggle it or not).

> Stephan
>
[quoted text clipped - 15 lines]
> > PPTools: www.pptools.com
> > ================================================

-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================

Reply to this Message