Suppressing SAP Analysis for Office Add-in Prompt

Dear Jen,

SAP Analysis for Office add-in has been installed on to my MS Excel 2016. This add-in appears as a tab “Analysis” in MS Excel.

If I make a change to my data from 7.00 to 6.00 and then close this workbook by clicking on the X at the top right, a pop-up prompt from the Analysis add-in will appear. This pop-up prompt is not issued from Excel or my VB codes.

I understand clicking on the X at the top right will invoke the Workbook_BeforeClose event in ThisWorkbook.
If I put this code “Application.EnableEvents = False” in Workbook_BeforeClose, this will suppress this pop-up prompt from the Analysis add-in. But, it will also suppress all further events which is not good for me.

Is there a way for VB to just detect this pop-up prompt and suppress it from appearing while not affecting all other events?

We only have the dll for this Analysis add-in but not the underlying codes.

Thank you in advance for looking into this issue for me.
I can be contacted on my mobile 07484 612 985. I can send you the screenshots if you could let me know how to get them across to you.

Kind regards,
Anthony Tan