Skip to Content
-1
Aug 25, 2020 at 02:05 PM

How to suppress the message: "Plan data not saved." when closing a workbook?

92 Views

Hello together,

When you close a Analysis for Office Planning Workbook in Excel and have changed some data you receive a message "Planning data not saved. Do you want to save the data."

data-not-saved.jpg

I am looking for a solution to suppress this message and handle the case differently.

I know the VBA Event "Workbook_BeforeClose" but so far I did not find a solution to know that this message is active and to suppress it because it's not shown in the "SAPListOfMessages".

Has anyone an idea?

Best regards

Attachments

data-not-saved.jpg (15.0 kB)