Solved: Trying to uninstall addin when closing file

[abhiker]

i am trying to uninstall an addin when i close my file. when i open certain files, i install it then. so i don't alway need the addin. this is the code i tried to use but it doesn't seem to do it. any help is greatly appreciated.

[VBA]
Dim bIsClosing As Boolean

' in case the user cancel the file close
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Cancel = False
bIsClosing = Not Cancel
End Sub

Private Sub Workbook_Deactivate()
On Error Resume Next
If bIsClosing = True Then
Application.AddIns("IclAddIn").Installed = False
End If
On Error GoTo 0
End Sub
[/VBA]

[Bob Phillips]

ARe you sure you ave the correct addin title? Remove the On Error and see what happens.

[mdmackillop]

The second sub does not get called. Why not
[VBA]Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.AddIns("IclAddIn").Installed = False
End Sub
[/VBA]

[abhiker]

thank you. this seems to work the way i want it to. have a good day.