Code below Deletes the Toolbar when the Workbook is closed:
Return to List
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.CommandBars("Test").Delete
End Sub
' If the toolbar is stored in a particular workbook -- it will still be there when the workbook or Add-In opens. Place this code in the workbook code area. Since an Add-In doesn't close until Excel is closed, there's no window to close, the toolbar wouldn't be deleted until then.