We have a macro that moves charts from Excel sheets into a PPT deck. It copies the charts from each worksheet and then pastes them as pics in the PPT.
I'd like to append some VBA to the end of the macro that will then go through the PPT and resize each pic (chart) so that it fits nicely within each slide.
You'll see what I mean if you look at the attached. Currently, the pics overlap the header and footer of the slides. I need them to line up and fit in an orderly fashion.
NOTES: On a yearly basis, our marketing dept is responsible for designing a new PPT template that we're required to use for all of our decks. The 2018 version of the template accommodated the pics properly, so sizing wasn't needed. With the new version of the template, the pics don't fit nicely.
Also, I realize that appending the code to the end of the existing macro is probably not best practice - but I am constrained by what leadership will allow, in terms of modifications to the code.
Thanks!
Bookmarks