Microsoft Excel Addin

[Tony McGee]

Hello all

I have written an Excel addin that adds a menu to Excel's main menu when
installed.

Everything works OK.

However, when you remove the addin by going to Tools > Addins & unchecking
the box beside its name, the menu (& all of the features available) for my
addin remains until such time as you close Excel & then restart Excel.

Is this normal or am I doing something wrong or is there a way to remove it
immediately when you uncheck the box beside its name?


Thanks
Tony McGee

 

[carlo]

That's normal.

But for that you have an event which is called:
AddInUninstall
you can look it up in the help.

in that event you could delete the menu
there's also an event AddInInstall, where you could add the menu, so
that you don't have to restart excel in order to see the menu.

hope that helps

Carlo

 

[papou]

Hi Tony

Create your Menu from the Workbook_AddinInstall event and delete it with the
Workbook_AddinUninstall

HTH
Cordially
Pascal