Thanks again Joel. But what if I wanted to make the macro available to others
in my office?
Thanks.
Bugzee

"joel" wrote:

I you are the only one who is going to use this macro then yo may consider
putting the macro in a personal.xls workbook. The personal workbook macros
will be available to you whenever you open up any workbook.

"Bugzee" wrote:

Thanks very much for your help, Joel. What I am trying to achieve is to have
a macro to set my default formats for a type of report. I would like this
macro to be accessible from any workbook. Any advice on how this can be done?
Thanks,
Bugzee

"joel" wrote:

I'm not sure what you are trying to do. You only need DLL decarations if you
are running a compiled code usually an .exe file or some other executable.
VBA macros are not executables. So if you are running a macro from any
microsoft office product to any other microsoft office product yo udon't need
any declarations.

VBA (Visual Basic) macro can either be placed in every workbook which is the
normal method for executing a macro. When you copu a workbook the macro is
automatically copied. You can also run a macro in another workbook (or a
macro in another microsoft office product). Is your question how to run a
macro in another workbook?

"Bugzee" wrote:

I am trying to get an Excel macro to run from any workbook by placing a
button on the menu bar. I do not know which DLL to include in the Public
Declaration. Can anyone advise me?
Thanks.
Bugzee