New charts take on ppt font / PPTColorsForNewGraphs

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
StephanM said:
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?
Click to expand...

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.
 
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
 
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).
Click to expand...

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.
Click to expand...

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).
 
Back
Top