Why not add a tool bar or menu option. The addin can create those and it
provides a simple interface for the users. I can send you an addin that I
have if you need and example...

--
HTH...

Jim Thomlinson


"Dave Stice" wrote:

Hello. I just joined this forum, so hopefully I won't ask any questions that
are too ignorant. I did a search on the subject and couldn't find what I
needed. Here is my problem:

I created a macro that I would like to be accessible to many users (Excel
2000). I'm also expecting that more bells and whistles will be added at a
later date, so I want to be able to update the macro from one central
location. Rather than go with the personnel.xls approach (which seems to
have many drawbacks), I saved the workbook as an add-in. I then went to the
add-in manager in a new workbook and selected the add-in I created. But when
I go to Tools, Macro, Macros..., the macro I created is not there under any
of the "Macros in" dropdown. Yet if I go to the Visual Basic Editor, it is
there exactly as created as a .xla file. So how do my users get to the
subroutines in the xla? They are public.

Dave