Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

How to share macros in powerpoint 2007?

100 views
Skip to first unread message

proshop

unread,
Dec 20, 2009, 9:31:01 AM12/20/09
to
Hi all,

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.

Steve Rindsberg

unread,
Dec 20, 2009, 12:45:53 PM12/20/09
to

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/


George Lee

unread,
Dec 21, 2009, 4:26:01 PM12/21/09
to
I'm trying to do the same thing. I can write add ins with VSTO and VS 2008
but I'd like to be able to use macros.

The article you reference seems to be specific to PP 2003. 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?

"Steve Rindsberg" wrote:

> .
>

George Lee

unread,
Dec 21, 2009, 4:44:01 PM12/21/09
to
D'uh! I found it. It's under PowerPoint Add-ins, an only completely obvious
choice.

Steve Rindsberg

unread,
Dec 21, 2009, 10:00:34 PM12/21/09
to
In article <F10B497C-DAB2-4138...@microsoft.com>, George Lee wrote:
> I'm trying to do the same thing. I can write add ins with VSTO and VS 2008
> but I'd like to be able to use macros.
>
> The article you reference seems to be specific to PP 2003.

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.

George Lee

unread,
Dec 22, 2009, 9:41:01 AM12/22/09
to
Thanks for the understanding.

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:

> .
>

Steve Rindsberg

unread,
Dec 22, 2009, 3:41:33 PM12/22/09
to
In article <32D963BC-7678-4413...@microsoft.com>, George Lee wrote:
> Thanks for the understanding.
>
> 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?

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.

0 new messages