Avatar of MonteDelMar
 asked on

Automatically load PowerPoint Addin (.ppam) (without user intervention) when PowerPoint starts

Hi Experts

We have a PowerPoint 365 addin (.ppam) that needs to be distributed to 100+ users and loaded when PowerPoint starts. Pushing the file out to the users is simple but, short of going around each user and manually loading the addin, is there a way of doing this so that it is loaded automatically when PowerPoint starts?

The .ppam contains a custom Ribbon and macro code. The default presentation template is a .potx file and contains only the slide layouts.

Things I have tried so far:

1. I have tried adding a Registry entry as follows: Computer\HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\PowerPoint\Addins\MSAL

I have tried the above path with both single and double backslashes.

2. I tried using a macro in another application (Word) to load the addin in Powerpoint. I thought that, once it had been loaded and PowerPoint closed, it would then be loaded automatically the next time PowerPoint is started. The macro in Word successfully loads the .ppam but, when PowerPoint is closed and re-opened, the .ppam addin is not loaded.

3. I've looked at various ideas around running an auto macro when PowerPoint starts. However, I do not *think* these work in 365 and we do not really want to have presentations based on a .potm file because of the security issues, especially if these are shared in that form outside the company (e.g. drafting a joint presentation).

4. I do not think there is a way to do this via GPO, but tell me I'm wrong!

I have reached the point where I am going around in circles and thinking perhaps I could run a macro, but I don't want a presentation based on a ,potm file. I cannot help feeling I am missing something straightforward here. Please tell me what it is.

Thank you so much for any help you can give me.

Microsoft PowerPointMicrosoft 365

Avatar of undefined
Last Comment

8/22/2022 - Mon

I think you need to set your add-in to run automatically when PowerPoint is opened. I'm sure one of the guys who does this on the regular will be by soon, but in the interim, have you checked the auto open information here? https://www.rdpslides.com/pptfaq/FAQ00741_How_can_I_get_my_code_to_run_automatically_when_a_presentation_opens-.htm
John Korchok

Here are some pages about how to do this with a GPO:
How to enable macro with group policy?
Enable Macro using Group Policy (About Excel, but the method is the same for PowerPoint.
Enabling Template Macros via GPO

And a page about trouble-shooting add-ins that don't load:
Troubleshooting Add-in Loading

Thank you both for taking the trouble to answer. I think perhaps I did not explain myself very well.

What I need to do is to have that addin loaded when PowerPoint starts up. The only way I have found to this successfully is to go through File, Options, Addins etc. If I do it this way then, when I close and re-start PowerPoint, the addin is automatically loaded.

However, I do not want 100+ users to have to do this themselves so I am looking for a way to automate it so that we can push this out to those users and they do not need to do anything except launch PowerPoint.

One potential solution might have been to run a macro when PowerPoint is launched but that, I think, would mean that the default template would need to be a .potm file - in order to contain said macro. (I am not even sure that the trigger macros work in 365.) I would rather not base a default presentation on a .potm template because of the potential security issues when sharing the presentation in that form.

I hope that explains it better. Thank you.
Your help has saved me hundreds of hours of internet surfing.

Oh, I think you should create an MSI and then push that out with a script that runs when the user logs on.

Thank you. That's going to create a whole new question :-D

:-) I wish I could help you with the specifics of MSI and rolling out with a script! All I know is that I generally have my add-in devs give me an MSI, and I give that to the IT staff. And the IT folks have said it's easy for them to install the MSI with a script.

I don't think either one is super difficult, but I unfortunately can't help with the details.
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.

Thank you, Echo_S. I am going to have a look into it. 
John Korchok

While researching for an add-in I'm currently writing, I ran across this page that explains how to set up a PowerPoint add-in that autoloads. Scroll about halfway down the page: ​Identifying your imageMso – Excel, Word & Powerpoint​​​

Thank you, John. I have not made this work yet but I will keep trying and post back.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy

Thank you to John Korchok and Echo_S for your kind efforts to help me.
I found that I needed to add the following entry to the Registry. It worked for me - I hope it helps someone else.

View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.

Thank you for posting back with your solution! I'm glad to hear you got it worked out.