Toggle Com AddIn Off Using VBA

[Rick93636]

I’ve read several posts here and elsewhere regarding turning off Com AddIns using VBA, however, I’m getting error messages that aren’t mentioned in those posts.

In my code I’ve tried using both the Com AddIn description and the ID

For this:

Private Sub TitusOff()
 
AddIns.Add("TITUS Classification for Microsoft Office").Connect = False

Or this:

Private Sub TitusOff()
 
AddIns.Add("TITUSClassificationForOfficeConnect").Connect = False

I get this error message:

Unable to get the Add property of the AddIns class

For this:

Private Sub TitusOff()
 
Const stAddinName As String = "TITUS Classification for Microsoft Office"
    Application.AddIns(stAddinName).Installed = False

Or this:

Private Sub TitusOff()
 
AddIns("TITUS Classification for Microsoft Office").Installed = False

Or this:

Private Sub TitusOff()
 
AddIns("TITUSClassificationForOfficeConnect").Installed = False

I get this error message:

Subscript out of range

Any suggestions? Thanks