Mega Code Archive

 

Categories / VisualBasic Script / Application

 

Ensuring that an accessible add-in is properly installed and workable

Private Sub Workbook_Open()    AddIns.Add FileName:=ThisWorkbook.FullName    AddInTitle = "title"    Application.EnableEvents = False    AddIns(AddInTitle).Installed = True    Application.EnableEvents = True End Sub