View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff[_2_] Harald Staff[_2_] is offline
external usenet poster
 
Posts: 449
Default Remove add-in - also remove toolbar

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