I have a .ppt file with macro in it(not created by me). Basically its a
simple macro that has a pop-up box and allows a user to choose a title for
the header and footer and inserts them into the slides.
I have no problem running the macro via "view > macros > Run ..." from the
original .ppt file.
However, the question is, how am I able to share this macro with other users
running office 07?
I have managed to solve a similar issue with excel 2007 by saving the macro
file as an Add-in, then import the Add-in to excel 2007, created a customize
button for the macro under "Excel options > Customize > Choose commands from
> Macros". It works nicely and each time I open a new excel document or an
existing one, I can simply click on the button to run the macro which inserts
the header and footer.
I like to do the same for powerpoint but after I've installed the Add-In, I
can't see the macro listed under "Powerpoint Options > Customize > Choose
commands from > Macros"
What can I do the share the macro with other users running office 2007?
Please advice.
Your add-in should create a toolbar+buttons(s) or add a menu item for users to
click.
Create an ADD-IN with TOOLBARS that run macros
http://www.pptfaq.com/FAQ00031.htm
==============================
PPT Frequently Asked Questions
http://www.pptfaq.com/
PPTools add-ins for PowerPoint
http://www.pptools.com/
Am I missing something?
"Steve Rindsberg" wrote:
> .
>
And 97 through 2002. And 2007. 2010 too. What a deal! ;-)
> Among other
> things, I assume you load the ppa or ppam through the Addin window of the
> Office button but there is no option for those two extensions. It looks like
> they want exclusively exe or dll.
>
> Am I missing something?
Yep, one teeny step: When you go to install the add-in, choose PowerPoint Add-ins
from the list box next to "Manage:" the click Go. You've chosen to add COM add-ins,
which are a different animal.
And thanks for asking ... I've updated the FAQ with new install instrux for 2007 and
2010.
While we're on the subject, I'd like to do the same thing but with the
ribbon, tabs, and groups. That is, create an addin, share macros, and access
them through ribbon tab. Is this possible?
"Steve Rindsberg" wrote:
> .
>
As explained, if you follow the instructions on the same web page we're talking about,
you'll get a new Add-ins tabl on the 2007/2010 ribbon. Any toolbars your add-in creates
will appear on that tab.
It's also possible to create your own ribbon tabs and buttons, but it's a very different
process and would mean maintaining several different versions of your add-in.
Google "ribbon xml reference" if you really *need* to create new tabs on the ribbon.