Macros not working when I save as a PPA?

  • Thread starter Thread starter Alex Gilbert
  • Start date Start date
A

Alex Gilbert

Hey folks, this is my first VBA project so let me know if I'm not
communicating my problem clearly enough.

So I'm using Office 2003 and I have a VBA project that contains a
number of macros working together:

The Auto_Open macro loads a new CommandBarButton. Clicking this button
calls a macro that executes .AddPicture on the Master Slide, loading a
custom button graphic that I want to be able to use when in Slide Show
view. Finally, this button graphic has another macro assigned to it
using the .ActionSettings(ppMouseClick).Run property.

Everything works as expected when I'm using the presentation in which
I am developing the VBA, and also when I save the presentation as a
template. However, when I save the presentation as a PowerPoint Add-
in, load it in a new, blank presentation, and then go through the
process, my custom button graphic isn't being assigned any actions. It
isn't clickable like it's supposed to be. When I edit it action
settings manually, I can see that the "Action on click" field is set
to none and the "Run macro" option is disabled.

This leads me to believe that something about saving as a PPA doesn't
include all the macros as it does in a presentation or a template. Is
there anybody who can tell me what I'm not understanding about this
process? A way to make this work the way I need it to? Maybe there's a
simple hack or workaround, that would be fine by me as well.

Thanks in advance!
 
Alex,
It seems like a problem in code rather the PPA. If you could post the
relevant routine that does not work then possibly myself and others here
would be able to help address it.


--
Regards,
Shyam Pillai

Image Importer Wizard
http://skp.mvps.org/iiw.htm
 
Hey folks, this is my first VBA project so let me know if I'm not
communicating my problem clearly enough.

So I'm using Office 2003 and I have a VBA project that contains a
number of macros working together:

The Auto_Open macro loads a new CommandBarButton. Clicking this button
calls a macro that executes .AddPicture on the Master Slide,
Click to expand...

Hold up there for a second. <g>
This all works when the presentation that includes the VBA is open, but when
you save as PPA, all slides/masters/etc are discarded. In order to do this,
your Auto_Open would have to start a new presentation or open an existing one
and then add the picture to it.

That might well be the problem. I'm guessing you also want to make sure you
don't have On Error Resume Next in your code. For now, let it spew all the
errors it likes. That's the only way you'll be able to track 'em down.
 
Back
Top