View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave Stice Dave Stice is offline
external usenet poster
 
Posts: 3
Default Expose macros with add-in

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