Recently amended VBA code causing saving error

Duhhh

Sorry. Just noticed that. User - Manager Password - secret

Sorry

These are the two codes I have recently added to.
"This Workbook"

Please Login or Register  to view this content.

And the other code is

And "Mort Fig"

Please Login or Register  to view this content.

Anyone got any ideas why I'm getting this saving loop when closing the workbook using the x. Does not happen when closing Excel by the x

Matt

Hi Matt,

Try the following code, with the changes in Red. Unfortunately, if the user presses the 'x' to close the file, and selects 'Cancel', your timer stops.

The simplest and most reliable way to fix the problem that I know of is to:
a. Disable the 'x' to close Excel.
b. Disable the 'x' to close the file.
c. Disable closing the file from the Excel Menu
d. Add a CommandButton to Save and Exit.
e. Add a CommandButton to Exit without Saving.

Options d. and e. would leave Excel Open if there were other open workbooks.

ThisWorkbook code module:

Please Login or Register  to view this content.

Lewis

Hi Lewis

that worked perfect. It now allows me close the workbook after saving only once. I notice the timer does stop after pressing cancel, option d & e probably look the best. Is there much in it to do those?
Matt