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