I have a very simple macro I want to run each time I close a workbook. Its
purpose is to uninstall thee excel add-ins. But the macro is not running. I
put it in "ThisWorkbook" in my Personal macro workbook and cannot figure out
why it is not running. I can't even get the messagebox to appear. Any help
is greatly appreciated.

Private Sub Workbook_BeforeClose(cancel As Boolean)

i = MsgBox("TESTING", vbOKOnly, "TESTING")
Call Uninstall_Essbase_and_SmartView

End Sub

Sub Uninstall_Essbase_and_SmartView()

AddIns("Hyperion Essbase OLAP Server DLL (non-Unicode)").Installed = False
AddIns("Hyperion Essbase Query Designer Addin").Installed = False
AddIns("Hyperion Smart View for Office").Installed = False
End Sub