Uninstall Add-in

[Jonathan78]

Hello all,

I use the following code as a add-in

Please Login or Register  to view this content.

And this is the macro it reffers to:

Please Login or Register  to view this content.

The problem with it is, that it does not uninstall the add-in. even after closing down excel.
Any ideas?

[royUK]

Not sure what you mean. An addin is always available if installed correctly. This event:
Workbook_AddinUninstall, does not install an addin, it runs when the addin is installed. Likewise the uninstall part only works when an addin is uninstalled.

Are you actually working with an addin that is installed correctly? Addins will have a *.xla or for versions later than 2007, a *.xlam extension.

If you want the menu to install each time the workbook is opened then use the WorkBook_Open event and the Workbook_BeforeClose event

Your code adds a Commandbar not an installation, this will only be visible in versions before Excel 2007, after that you will need to open the addins tab

[Jonathan78]

Hello Roy,

This is the first time I'm working with it
It has a XLA-extension [I am using 2003]

What I a actually like to accomplish is that the add-in needs to be selected [installed] each time your'e going to use it [or at least doesn't appear on the menu-bar unless selected]
This because when it is hit on a wrong sheet it will destroy the sheet.

Although I am not sure if it can be called a add-in but the MrExcelHtmlMaker would be the best solution.
It needs to be doubleclicked each time your'e going to use it and will uninstall itself upon closing down excel.

[royUK]

The simplest solution is to make the code check the correct page is selected, or better still don't write the code as you have so that it acts on the ActiveSheet. You should specify the sheet in the code. This might work better

Please Login or Register  to view this content.

[Jonathan78]

It gives an error on line: [Method "Delete" of object'_CommandBarButton' failed]

Please Login or Register  to view this content.

btw. the name of the sheet is not always the same as it is used on a file imported from another program.