Weird template/macro behavior ??

Discussion in 'Microsoft Excel Programming' started by David, Aug 12, 2003.

  1. David

    David Guest

    ok, I figured out how it happened (I think)
    When I assigned the macro to a toolbar button, I let it
    default to 'any workbook' and I had another workbook in
    the same folder with an outdated version of the macro.
    I'm still not sure how the macro disappeared from my
    template but that is how it was executing ther macro in
    another XLS file.


    >-----Original Message-----
    >Here is my situation:
    >I have an XLT template. When I open it there are no

    macros
    >listed in Tools--Macros--Macros.
    >However, when I save it as an XLS, I can press my command
    >button and the macro runs.
    >The only place I can find the macro is in another XLS

    file
    >in the same folder.
    >Somehow my template is referring to the macro in another
    >XLS file and this reference gets carried over when I save
    >an XLS based on the template.
    >I have no idea how this happened but how do I fix it and
    >prevent it from happening again.
    >I'm using Win 2000 and Excel 2000.
    >
    >- David
    >.
    >
     
    David, Aug 12, 2003
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Tom Ogilvy

    Re: Weird template/macro behavior ??

    Tom Ogilvy, Aug 12, 2003, in forum: Microsoft Excel Programming
    Replies:
    0
    Views:
    264
    Tom Ogilvy
    Aug 12, 2003
  2. Guest

    Weird behavior of VLOOKUP

    Guest, Apr 30, 2005, in forum: Microsoft Excel Programming
    Replies:
    2
    Views:
    226
    Guest
    Apr 30, 2005
  3. Guest

    Weird Sorting Behavior

    Guest, May 3, 2005, in forum: Microsoft Excel Programming
    Replies:
    1
    Views:
    165
    Dave Peterson
    May 4, 2005
  4. DocAlan02

    Weird behavior with Macro VB window in Excel 2003

    DocAlan02, Apr 1, 2008, in forum: Microsoft Excel Programming
    Replies:
    0
    Views:
    148
    DocAlan02
    Apr 1, 2008
  5. Will Specht

    Weird Macro Behavior

    Will Specht, Sep 25, 2008, in forum: Microsoft Excel Programming
    Replies:
    2
    Views:
    131
    Will Specht
    Sep 25, 2008
Loading...

Share This Page