Link to home
Start Free TrialLog in
Avatar of Dov_B
Dov_B

asked on

in MS Word VBA How can I apply one of the picture styles that appears on the ribbon for pictures

it seems that the picture styles listed on the ribbon are made up of a complex recipe of effects. Although Microsoft makes available the individual effects through vba that is not helpful enough because I don't have the time to figure out which efects to combine to get the beautiful picture styles Microsoft offers in its ribbon.

Using the macro recorder is of no use because it doesn't work when applying picture styles. Is there any place that reveals the secret ingredient of effects used to create the ribbon styles or is there away of applying them progromaticly using autohotkeys or some kind of scripting program? Keep in mind that I may have up to 200 pictures in a single word document to which I wish to aply the style to.
Avatar of Chris Bottomley
Chris Bottomley
Flag of United Kingdom of Great Britain and Northern Ireland image

Don't know if I can answer yet but what are you looking for, to apply a given style using VBA or to create your own style at run time?

Chris
Avatar of Dov_B
Dov_B

ASKER

TO APPLY A GIVEN STYLE USING vba
SOLUTION
Avatar of Chris Bottomley
Chris Bottomley
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Dov_B

ASKER

Thanks but I mean picture styles
ok, apologies.  i've never used anything of the sort and cannot say I have ever heard of or seen them.

Looking around at the interface and on t' web however the short answer seems to be no you cannot short of breaking down the effects of the style you want and applying each of the component properties independantly.

Chris
Avatar of Dov_B

ASKER

I just had a thought perhaps after applying a picture style there is a way to cycle through all its properties and list them in the debug window so I can easily write a macro that sets all the appropriate properties to match the picture style
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial