Thanks for the quick reply Jim,

I'll try your suggestion for the second part in a bit.

As for the first question, let me try to explain the problem in greater
detail.

My code is in an add-in that is loaded every time any excel file is open, so
naturally the toolbar gets created any time any file is open. What i want to
do is to have the toolbar created only when the file i need to work with is
opened, and do nothing if any other excel file is open.

Here's what i tried, but it didn't work. It just doesn't show the toolbar at
all.

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Call deleteMenu
End Sub

Sub workbook_open()

Dim bk As Workbook

On Error Resume Next
Set bk = Workbooks("CombinedBatchStandardTransactions[1]")
If Not bk Is Nothing Then GoTo goOn

Set bk = Workbooks("CombinedBatchStandardTransactions[2]")
If Not bk Is Nothing Then GoTo goOn

Set bk = Workbooks("CombinedBatchStandardTransactions[3]")
If Not bk Is Nothing Then GoTo goOn

Set bk = Workbooks("CombinedBatchStandardTransactions[4]")
If Not bk Is Nothing Then GoTo goOn

Set bk = Workbooks("CombinedBatchStandardTransactions[5]")
If Not bk Is Nothing Then GoTo goOn
   
Exit Sub

goOn:

Call deleteMenu

Sheet1.Shapes("NL").Copy

Set MenuObject =
Application.CommandBars(1).Controls.Add(Type:=msoControlPopup, before:=10,
temporary:=True)
MenuObject.Caption = "&NavSol"
Set MenuItem = MenuObject.Controls.Add(Type:=msoControlButton)
MenuItem.OnAction = "mdlInv.formdaily"
MenuItem.Caption = "&DBE"
MenuItem.PasteFace

End Sub

Sub deleteMenu()
On Error Resume Next
Application.CommandBars(1).Controls("NavSol").Delete
On Error GoTo 0
End Sub

Is it not working because the file is not actually open yet? Can that be the
case?

Thanks again.