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

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

On Jan 10, 4:59*pm, "Tony McGee" wrote:
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

Hi Tony

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

HTH
Cordially
Pascal

"Tony McGee" a écrit dans le message de news:
...
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