LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel: Expose whole window or at least top resize handles. Reinie Excel Discussion (Misc queries) 1 August 25th 09 04:11 PM
Searching for link: Bob Phillips expose on NAMES davidm Excel Programming 2 January 28th 06 08:10 AM
How can I expose the actual column & row headers in excel? Juanita Excel Discussion (Misc queries) 1 December 1st 05 06:18 PM
How can I expose the TextBox BeforeUpdate event to my user class? bereid Excel Discussion (Misc queries) 0 November 30th 05 05:00 PM
Data (entry) form - expose properties? Poseur Excel Programming 3 September 27th 04 04:38 PM


All times are GMT +1. The time now is 10:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"