View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default 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