PowerPoint Is Not Excel!
I have spent probably 90% of my Microsoft Office usage inside Excel. Because of this, I tend to assume if I can do it in Excel, I probably can do it in any other Office application. I mean, they're created by the same company, right? It only makes sense that if there is a ThisWorkbook Excel VBA command and a ThisDocument Word VBA command, that there would also be a ThisPresentation command within PowerPoint's VBA language. Wrong! Well, this post is going to cover another scenario where I assumed PowerPoint would act more like it's siblings and luckily, thanks to some outside inspiration, I can provide you with a great workaround.
If you use VBA macros, then you most likely understand how powerful they can be when you write code that works in a more generalized fashion instead of for a particular spreadsheet or Word document. Examples could include formatting a selection of cells a particular way (ie fill color, font size, number format, etc..) or automatically emailing your spreadsheet as an attachment to your manager. These "personal" macros end up saving us time and hassle on a daily basis, so when I started venturing into writing VBA code for PowerPoint, I naturally wanted to develop personal macros for my presentations as well.
One Big Problem...
After becoming extremely confused, I came to find out PowerPoint doesn't allow for a personal macro file. My next thought was to create an add-in file and link the subroutines (macros) to my Quick Access Toolbar (QAT). Unfortunately, the PowerPoint QAT only will bring in VBA macros from macro-enabled presentations. Below I have a PowerPoint Add-in file and a macro-enabled file opened. ONLY the macro-enabled code is shown in the listbox! What's the point of even giving us this option Microsoft!?
So Here's The Workaround
First off, I want to thank PowerPoint MVP John Wilson for providing me with this solution and offering to share the workaround he has created. With that said, the way John recommends executing personal macros is through the PowerPoint Ribbon. Now you might be thinking, "I don't have any idea how to create my own ribbon!" or maybe even "I didn't know you could make your own ribbon tab?!" Well that's where John's AMAZING idea comes into play. He sent me a template he created, letting anybody add 5 macros to a new ribbon tab with custom button labels. This was pure genius and I immediately thought to myself, "Why didn't I think of that"! I made some modifications to John's original Ribbon template based on my personal preferences and I think your going to love this workaround.
Included inside the PowerPoint file (download below for free) is a set of instructions that will show you where to add your VBA code subroutines and how to save the file as a PowerPoint add-in file. Please let me know in the comments section below if you have any trouble with this file. Enjoy!
How Do I Get The Custom Ribbon Template?
As always, in order to download this example template you will need to be a subscriber of my free newsletter. If you click the green button below you can easily sign up and you will be emailed the password to get into the subscribers-only area of this website.
Share This Post!
Did you find this post helpful? Do you want to support this blog because you're just that awesome?! By sharing this post on Facebook, Twitter, or Google+ you are not only providing others with great information, you are creating exposure for The Spreadsheet Guru website. Growing this community is my number one goal as I have found learning to increase exponentially when lots of people are contributing to the conversation. Learning is the whole reason why this blog exists! If you want to spread the word just click on the Share button right below this paragraph (next to the Like button -- I enjoy "likes" too!) or on the Floating Share Bar to the left and select your preferred social medium. Thank you so much for reading and I hope I can continue to provide you with great content in the future! Cheers!