Results 1 to 5 of 5
  1. #1
    3 Star Lounger MacroAlan's Avatar
    Join Date
    Feb 2003
    Location
    St Louis, Missouri, USA
    Posts
    254
    Thanks
    6
    Thanked 1 Time in 1 Post

    Add-in not Recognized (2000/SR-1)

    For a week, I have been making changes to an add-in and dutifully saving often. This morning, I made a zillion changes (they moved some columns around) and tested many times.

    All of a sudden, Excel crashed (and burned) <img src=/S/fire.gif border=0 alt=fire width=15 height=15> and now it will not recognize the macro in the add-in. It shows in my custom menu and if I go into the code, it is there.

    I cannot go into an Add-In module from the Macros menu. <img src=/S/help.gif border=0 alt=help width=23 height=15>
    Alan

  2. #2
    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-in not Recognized (2000/SR-1)

    Macros in Addins are not meant to run from tools- macro - macros and (unless things have changed from XL97) will not be displayed in that dialog. The dialog only shows code from worbooks, not code from addins.

    Steve

  3. #3
    3 Star Lounger MacroAlan's Avatar
    Join Date
    Feb 2003
    Location
    St Louis, Missouri, USA
    Posts
    254
    Thanks
    6
    Thanked 1 Time in 1 Post

    Re: Add-in not Recognized (2000/SR-1)

    The problem is not being able to run the macro directly. We have a menu item to run the macro.

    When the menu is clicked, it cannot find the macro even though I can see it plain as day. Message:
    <pre>The macro blahblah.xla!ReFormatText cannot be found.</pre>


    I have looked for and not found the XLB. We re-installed Excel. Same result
    Alan

  4. #4
    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-in not Recognized (2000/SR-1)

    Try deleting the button and creating a new one, or assign a different macro to the button, then reassign the addin macro. It might have "lost the link" in the crash and retelling it where it is might be required.

    Steve

  5. #5
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Add-in not Recognized (2000/SR-1)

    I have seen this message occur when I named my project the same as one of the macro's in it. Weird, but easy to solve.

    Also, I tend NOT to edit add-ins, I prefer editing a normal workbook and when done save-as filetype addin. Saving from the VBE (as one needs to do with an addin) may sometimes cause trouble with some Excel versions (particularly 97 if I remember correctly)
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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