PowerPoint VBA Add-in distribution issues

M

Mike Lindeboom

I am testing how to deliver a PowerPoint 2000 VBA Add-in.

What I did:

I have signed my addin using the selfcert.exe program. To install to a
new machine I am copying the ".ppa" file to a directory and updating
the registry to point to it. The reg script I am using has the
following text:

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\Software\Microsoft\Office\9.0\PowerPoint\AddIns\CertTest]
"Path"="C:\\Program Files\\Microsoft
Office\\Office\\Startup\\CertTest.ppa"
"AutoLoad"=dword:ffffffff


The problem I am having:

On a Windows 2000 machine, if I login as a user with admin privileges,
the add-in seems to execute with no problems (I registered the add-in
as this user). On the same machine if I login as a user without admin
privileges the add-in does not execute.

I tried an additional experiment as the same user (no admin
privileges). I used the add-in menu to attempt to load the add-in.
PowerPoint displays a message that the add-in is already loaded.

Can anyone tell me what the issue might be? (I have tried playing with
the macro security settings and the macro is a simple "hello world"
using a message box.)
 
S

Steve Rindsberg

I have signed my addin using the selfcert.exe program. To install to a
new machine I am copying the ".ppa" file to a directory and updating
the registry to point to it. The reg script I am using has the
following text:

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\Software\Microsoft\Office\9.0\PowerPoint\AddIns\CertTest
]
"Path"="C:\\Program Files\\Microsoft
Office\\Office\\Startup\\CertTest.ppa"
"AutoLoad"=dword:ffffffff

Try using this instead:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\9.0\PowerPoint\AddIns\YourAddin
Name

I'm not sure why it's working at all as is ... my guess is that you're
seeing leftover effects from previous manual installs (ie, Tools, Addins,
Add)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top