Hello. This is a pretty simple question, but for some reason I haven't been
able to figure out how to do it. If I write some vba code and compile it, is
it possible to get this macro to show up on the Tools-Macro menu so people
don't have to enter the code editor to run the macro? Thanks.

If you put it in a standard code module, don't make it Private, don't make
the module Private, and don't have arguments, it should show fine.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"JacksonRJones" wrote in message
...
Hello. This is a pretty simple question, but for some reason I haven't
been
able to figure out how to do it. If I write some vba code and compile it,
is
it possible to get this macro to show up on the Tools-Macro menu so
people
don't have to enter the code editor to run the macro? Thanks.

Macro won't show up in the Macro Dialog sheet if they are
Private, or the module has Option Private Module at the top, or
the macros take parameters, or the macro is a Function instead of
a Sub. Other than that, they should appear in the list.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"JacksonRJones" wrote
in message
...
Hello. This is a pretty simple question, but for some reason I
haven't been
able to figure out how to do it. If I write some vba code and
compile it, is
it possible to get this macro to show up on the Tools-Macro
menu so people
don't have to enter the code editor to run the macro? Thanks.

On Thu, 11 May 2006 11:40:30 -0500, Chip Pearson wrote:

Macro won't show up in the Macro Dialog sheet if they are
Private, or the module has Option Private Module at the top, or
the macros take parameters, or the macro is a Function instead of
a Sub. Other than that, they should appear in the list.

To clarify, the macro doesn't show up if it has non-optional parameters.
Make them all optional and it will show up.

Don <www.donwiss.com (e-mail link at home page bottom).