Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

create and use an add-in in powerpoint 365

Status
Not open for further replies.

aldi07

MIS
Jun 22, 2010
100
CA
I created a vba (macro) in powerpoint 365. I would like that vba to be launched by and add-in button on the ribbon.
How would I do that?
Thank you.
 
If I understand correctly you can
[ol 1]
[li]Right click the ribbon and select "Customize the Ribbon"[/li]
[li]Create a custom group on one of the Main Tabs[/li]
[li]Change "Popular Commands" to "Macros"[/li]
[li]Select the macro to add[/li]
[/ol]


Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016
 
Hi dhookom,
Here are all the steps:

Code:
1-	Create a new Powerpoint presentation
2-	Click the developer tab
a.	If the developer tab does not appear:
i.	File/Options/Customise Ribbon
ii.	Enable the developer tab on the right hand side
3-	In the developer tab, click the visual basic button
4-	Add a module
5-	Type the following macro:
Sub ShowMessage
    MsgBox “This is a test”
End Sub
6-	Close the visual basic editor
7-	Save your presentation under the name of your choice. Here we will use Addin-test
8-	Add a button to the ribbon:
a.	Use the software Office RibbonX Editor. If you don’t have it, you can download it for free.
b.	Open the Office RibbonX Editor
c.	Open the Addin-test
d.	Right click on it, and insert a custom UI Part
Then you can use this type of XML file:
<customUI xmlns="[URL unfurl="true"]http://schemas.microsoft.com/office/2006/01/customui">[/URL] 
   <ribbon> 
     <tabs> 
       <tab id="CustomTab" label="My Tab"> 
         <group id="SampleGroup" label="Sample Group"> 
           <button id="Button" label="Insert Company Name" size="large" onAction="ThisDocument.InsertCompanyName" /> 
         </group > 
       </tab> 
     </tabs> 
   </ribbon>
 </customUI>
e.	Change the XML file to look like the following:
<customUI xmlns="[URL unfurl="true"]http://schemas.microsoft.com/office/2006/01/customui">[/URL] 
   <ribbon> 
     <tabs> 
       <tab id="CustomTab" label="Office Addin"> 
         <group id="SampleGroup" label="Messages"> 
           <button id="Button" label="Show Messages" size="large" onAction="ShowMessage" /> 
         </group > 
       </tab> 
     </tabs> 
 </ribbon>
</customUI
f.	Close the Powerpoint file
g.	Save the Xml file by clicking on “Save”
h.	Close the Xml file
9-	Reopen the Powerpoint presentation
10-	You will see the Office Addin button appearing on the ribbon
11-	You can then change the visual basic editor, and change the macro at will
12-	You should save the presentation also as a ppam file to make it part of the add-ins. It will automatically be saved using the path:
C:/Users/Your Name/AppData/Roaming/AddIns/
13-	Click on the save button
14-	You now have to install the add-in:
a.	Open your Powerpoint presentation
b.	Click on the developer button
c.	Click on PowerPoint Add-ins
d.	Click Add New
e.	Select the Addin-test.ppam
f.	Close the dialog box
g.	You now have the Office Addin button appearing
You might want to listen to the youtube link I sent in my previous post. The explanations are more complete.
Hope it helps.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top