Powerpoint vba problem

[Troot]

Hi all,

First, a brief history. I started out writing a vba script in word
which would be replicated throughout the company using the templates
folder. Since then Word has been dropped and we're moving to Powerpoint
(yeahhh, wasted effort ;o)

So I did up a few powerpoint vba script (havn't worked with powerpoint
before). I saved the file closed it and came back to it the next day.
Now NOTHING will run from the toolbar I designed. I can run from the
Tools-->Macros menu. Does anybody know what I might be doing wrong?

I am using Office 2000

Thanks
John

 

[Steve Rindsberg]

First, a brief history. I started out writing a vba script in word
which would be replicated throughout the company using the templates
folder. Since then Word has been dropped and we're moving to Powerpoint
(yeahhh, wasted effort ;o)

Worse. You can't distribute macros in PPT templates the way you can in Word.
There's no notion of document/template-specific customizations like toolbars.
There's no autorun directory.
You've entered a very, very different world.

To make toolbars and macros available to multiple users, you'll need to create
and distribute PowerPoint add-ins.

Have a browse here:

Creating and Installing Add-ins, Toolbars, Buttons
http://www.rdpslides.com/pptfaq/index.html#Creating_and_Installing_Add-ins,_Too
lbars,_Buttons_

Particularly:

Create an ADD-IN with TOOLBARS that run macros
http://www.rdpslides.com/pptfaq/FAQ00031.htm

 

[Troot]

Thanks for that Steve,

could have been peeing against the wind there for a while ;o)
I read that article you've linked to, and I have a question, if you
have the time.

I have my toolbars designed up in Powerpoint, but they don't go in the
add-in, do they? So how do I provide some way to launch an interface to
the macros. The only thing I can think of is to use the Auto_Open sub
and then launch a vba form. Do I have this right?

Thanks
John

 

[Steve Rindsberg]

Thanks for that Steve,

could have been peeing against the wind there for a while ;o)
I read that article you've linked to, and I have a question, if you
have the time.

I have my toolbars designed up in Powerpoint, but they don't go in the
add-in, do they?

Yes and no. First: Forget everything you know about toolbars from Word. This
is a different world. Really. ;-)

The addin needs to create the toolbar programmatically. There's no way for it
to grab and retain one you've created manually.

So how do I provide some way to launch an interface to
the macros. The only thing I can think of is to use the Auto_Open sub
and then launch a vba form. Do I have this right?

Close ... Auto_Open should check for the toolbar and if it's not there, create
it.

The links I pointed to before should have examples of how to do this.

 

[Troot]

Thanks for that Steve, it was really helpfull ;o)