Remove add-in - also remove toolbar
You should do it in the addin, by adding code in the BeforeClose event of
the addin.
Just give your toolbar a unique tag when you create it and delete it with
Application.Commandbars.FindControl(Tag:="myTag"). Delete
--
__________________________________
HTH
Bob
"Flemming" wrote in message
...
Hi Harald
I can remove a toolbar(commandbar) with code from within Excel, but it
need to be something that can be run from the uninstaller and hopefully
when Excel are closed.
/Flemming
"Harald Staff" wrote in message
...
Hi Flemming
Run this little macro he
Sub Clean()
Dim TB As CommandBar
For Each TB In CommandBars
If TB.BuiltIn = False Then
If MsgBox("Delete " & TB.Name & "?", _
vbYesNo + vbQuestion) = vbYes Then
TB.Delete
End If
End If
Next
End Sub
HTH. Best wishes Harald
"Flemming" wrote in message
...
Hi,
I have made an Excel Add-In that I instal using an homemade MSI
package - this of cause activates the Add-In in Excel so the user are
ready to work...
BUT uninstall... well it works fine - removes the xla file and cleans
the reg.db but the toolbar in Excel remains there..
I can of cause delete the file Excel11.xlb to delete ALL custom
toolbars... but thats really not an option!
Any ideas to how remove the toolbar for my add-in when the uninstaller
does it's job?
Thanks,
Flemming
|