Thread: VBA Macro text
View Single Post
 
Old 06-15-2011, 08:13 PM
joferder joferder is offline Windows Vista Office 2007
Novice
 
Join Date: May 2011
Posts: 5
joferder is on a distinguished road
Angry VBA Macro text

I am trying to write a macro for powerpoint, but for some reason our network at work has the ability to write macros disabled. So I have to come up with a work around for this and I think I have come up with a partial solution, but now I need help. I have the ability to get into the Visual Basic editor, so I figure that I can just put the macro in that way. Here is where I need help though.

I am looking for VBA code for a macro that will do two different things. I am pasting a lot of images from webpages and I need them to all be resized to 7.5" X 10". If there is a way to make it so that the image is centered on each slide that would be great, but not completely necessary. After the resize, I would like the macro to also make it so that the selected image is sent to the back (I normally right click the image and then select "Send to Back").

I would like the macro to be able to be applied by hitting something like Ctrl+E (or any other letter that currently isn't being used and is somewhat easy to type).

I would really appreciate any help that anyone could give. This has been a project that I have been working on for several months and I keep hitting dead ends and I am thinking that this may be one of the last things I can try.

Thanks in advance for any and all help.

John
Reply With Quote