Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel: Expose whole window or at least top resize handles. | Excel Discussion (Misc queries) | |||
Searching for link: Bob Phillips expose on NAMES | Excel Programming | |||
How can I expose the actual column & row headers in excel? | Excel Discussion (Misc queries) | |||
How can I expose the TextBox BeforeUpdate event to my user class? | Excel Discussion (Misc queries) | |||
Data (entry) form - expose properties? | Excel Programming |