Addin remains in memory!

[Rob]

I have loaded an addin I developed with much help from others and decided to
make some small changes; when testing / running through the VAB browser all
works well. However when run via a menu item in Excel as it's designed, the
original addin runs. I have loaded and unloaded the addin, I've restarted
Excel and the PC but still the original addin is the one that runs.

Any ideas?

Thanks, Rob

[Dave Peterson]

It sounds like your menu item still points at the macro in the original
workbook.

One neat way to avoid this problem is to build those changes to the menu each
time the workbook/addin opens (and destroy it on the way out).

If you like this idea, you may want to look at how John Walkenbach did it in his
MenuMaker.xls workbook.

You can find it:
http://j-walk.com/ss/excel/tips/tip53.htm


Rob wrote:
>
> I have loaded an addin I developed with much help from others and decided to
> make some small changes; when testing / running through the VAB browser all
> works well. However when run via a menu item in Excel as it's designed, the
> original addin runs. I have loaded and unloaded the addin, I've restarted
> Excel and the PC but still the original addin is the one that runs.
>
> Any ideas?
>
> Thanks, Rob

--

Dave Peterson

[Rob]

Thanks Dave. Eventually got it working by changing the Sub name and
resaving the file.

Regards, Rob

"Dave Peterson" <[email protected]> wrote in message
news:[email protected]...
> It sounds like your menu item still points at the macro in the original
> workbook.
>
> One neat way to avoid this problem is to build those changes to the menu
> each
> time the workbook/addin opens (and destroy it on the way out).
>
> If you like this idea, you may want to look at how John Walkenbach did it
> in his
> MenuMaker.xls workbook.
>
> You can find it:
> http://j-walk.com/ss/excel/tips/tip53.htm
>
>
> Rob wrote:
>>
>> I have loaded an addin I developed with much help from others and decided
>> to
>> make some small changes; when testing / running through the VAB browser
>> all
>> works well. However when run via a menu item in Excel as it's designed,
>> the
>> original addin runs. I have loaded and unloaded the addin, I've
>> restarted
>> Excel and the PC but still the original addin is the one that runs.
>>
>> Any ideas?
>>
>> Thanks, Rob
>
> --
>
> Dave Peterson