Keep macro in toolbar?

[Katanna]

I know how to keep a macro in the toolbar, but I want to be able to
call a macro without it's specific file being opened. Right now, I
have several macros in the toolbar, but the file in which they
originated has to be open for the macro to run. Is there a way to
call these macros without opening a file?

Matthew

 

[Elliott Roper]

I know how to keep a macro in the toolbar, but I want to be able to
call a macro without it's specific file being opened. Right now, I
have several macros in the toolbar, but the file in which they
originated has to be open for the macro to run. Is there a way to
call these macros without opening a file?

There are two related methods I can think of:-
1. Use the organizer in Tools » Templates and add-ins... to get the
macros into your Normal template. Use the originating file as the
source of the macros.
2. Go one step further and create a global template and then add it to
your startup items. The advantage to that is that you are less likely
to pooch it if your Normal becomes unwell.

 

[John McGhie]

Hi Matthew:

Elliot has given you the simplest method, which is to place the macros you
want to use in a global template.

The Normal template is the easiest one to use, but as he says, you can also
use a global add-in in your StartUp folder.

If neither of these suit your purpose, you can use a VBA Run method. In the
VBA help, look up "Run Method" for an explanation and examples.

And come back here if you run into trouble: it's nasty

BTW: The literal answer to your question is "No." Word must open the
template storing the macro, in order to compile and load its code. So in a
literal sense, the file must be "open".

However, by using a global template or a Run command, Word will open the
required template in the background so you do not have to do anything.

Cheers

I know how to keep a macro in the toolbar, but I want to be able to
call a macro without it's specific file being opened. Right now, I
have several macros in the toolbar, but the file in which they
originated has to be open for the macro to run. Is there a way to
call these macros without opening a file?

Matthew

--
Don't wait for your answer, click here: http://www.word.mvps.org/

Please reply in the group. Please do NOT email me unless I ask you to.

John McGhie, Consultant Technical Writer
McGhie Information Engineering Pty Ltd
http://jgmcghie.fastmail.com.au/
Nhulunbuy, NT, Australia. S12.22.1918,E136.99.5392
+61 4 1209 1410, mailto:[email protected]

 

[Katanna]

Thanks guys, I will try those things (I am headed out of town first).

If it helps, I forgot to tell you some info: I am running Office for
Mac 2004, and I am specifically using PowerPoint, although I would
guess that your posts still apply.

Thanks again!

Matthew