Closing down workbooks

[DonB]

I have produced a workbook which has a significant number
of macros, one of which is to close the workbook, first
checking if it has been saved and then closing if saved.
The problem is that if the user, instead of using this
facility clicks the Excel close cross, the workbook closes
without saving and without the usual Excel message box
asking if the workbook is to be saved. Is there any way
that any of my macros may be disabling this and/or is
there any way of restoring it.

Many thanks in anticipation

DonB

 

[papou]

Hello DonB
Unfortunately if your user has disabled macros while opening your workbook
there is no workaround.
If this is not the case, you can use the Worbook_BeforeClose event to force
saving changes.

HTH
Cordially
Pascal