Results 1 to 3 of 3

Thread: Add Ins (2003)

  1. #1
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Cheltenham, Gloucestershire, England
    Posts
    214
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Add Ins (2003)

    I have a handout I got from a Microsoft Seminar which says

    Add-Ins
    If you have a set of macros that are contained within one workbook, perhaps the best way of making them available throughout the whole of Excel is to save the workbook as an Add-In (choose Add-In as the file type in the Save As dialog box). You can then go to the Tools menu, choose Add-Ins and browse to find the add-in file. Once the add-in has been added in this way, the macros that are contained within it will automatically be available in every Excel session.
    This is also an effective way to share your macros with other users; they can simply add your add-in file into their environment as described above

    So I have created my file, added a macro, saved it as an add in. Gone to Add Ins, Browse, sure enough it is there and when inserted appears on my add ins list. However when I then try to go Tools, Macros, Macros there is nothing there. I go into VB and the addd in and the module is shown on the explorer.

    How do I get to the macros in the normal course of events tro work from my worksheet please?

  2. #2
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Add Ins (2003)

    The functionality has to be made available either through an additional choice on the Worksheet Menu Bar or through a Custom Toolbar that loads with the Add-In (and unloads when then Add-In is unloaded). The functionality you are seeking is best suited for a <!post=Personal.xls,118382>Personal.xls<!/post> file. There have been many threads on Customised Toolbars - which are available through a Search on the Excel Board. HTH
    Gre

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Add Ins (2003)

    The macros in addins (as you have discovered) do not appear in the macro list.

    Toolbars are usually created to run the macros. See the StarPost Distributing an Excel application with toolbars (5/95/97/2000/2002)
    by Jan Karel <!profile=Pieterse>Pieterse<!/profile> for some additional info.

    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •