Everything about PowerPoint programming including VBA, VSTO, and more.
Jamie Garroch, CEO of GMARK Ltd., founded the company in 2009 to provide presentation professionals with PowerPoint software, content and training. Jamie uses PowerPoint for most of his graphic needs, for everything from designing logos to creating web banners and even printed marketing collaterals. He also uses PowerPoint as a programming environment to create custom programming procedures and PowerPoint add-ins.
In this conversation, Jamie discusses what the upcoming PowerPoint 2013 offers developers, and about the rumors that apps will replace add-ins soon.
Steve Rindsberg has been associated with PowerPoint since the product originated more than two decades ago — his PowerPoint FAQ site is a treasure trove of PowerPoint information. When he’s not updating his site, he’s creating new PowerPoint add-ins that expand possibilities within PowerPoint. Steve’s also into a lot of print technology related stuff.
In this conversation, Steve discusses what the upcoming PowerPoint 2013 offers developers, and about the rumors that apps will replace add-ins soon.
Do you want to remove all animations from your slides? You may want to remove animations for a variety of reasons: maybe the sequencing is all messed up, and starting all over again seems like a great idea. But one look at your Animations task pane reveals tens or hundreds of animations on each slide. Is there a magic button somewhere in PowerPoint that can get rid of all animations all together?
Yes, you can do this easily in PowerPoint using some simple VBA code, as John Wilson of PowerPoint Alchemy explains. John adds that this only removes animations from individual slides, and not any animations added within the Slide Master.
Do you want a random number generator for your PowerPoint slide? Do you want some numbers from a chosen sequence of numbers to pop up every time you click? Yes, you can do this in PowerPoint using some simple VBA code, as Steve Rindsberg of PowerPoint FAQ explains.
First you need to know how you can run VBA scripts in PowerPoint. Then use this code. Explore the code a bit though since Steve has put in some helpful comments so that you can edit some values as required.
VBA stands for Visual Basic for Applications and is a programming language subset of Microsoft Visual Basic. With VBA, users can control several options in programs such as PowerPoint that support VBA. Most versions of PowerPoint on Windows do support VBA while the same is not true for most Mac versions of PowerPoint. Thus, this post assumes you are using a Windows version of PowerPoint or another Office program.
Most Microsoft Office applications such as Word, Excel, and PowerPoint work with VBA. There is an extensive amount of information available online, including at the Microsoft site about VBA. There are also many VBA users who are always ready to help others. You can find many questions about VBA in Microsoft Office applications answered in the Microsoft Answers forums.
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.