I have an add-in loaded all the time that checks any opened workbook name
for a specific string. The below code does this except when excel is opened
with no workbook (i.e. from Programs Menu). This code resides in the
App_WorkbookOpen event in the add-in.
How can I suppress the error generated when no workbook is opened when excel
opens and is loading my add-in with below code? The
Application.ActiveWorkbook.Name object is null and that's causing the error.
If InStr("History by Length", Application.ActiveWorkbook.Name) > 0 Then
MsgBox "it is our file"
Call CreateMenu
End If
Bookmarks