Good evening,

I'm having some handling the closing of a workbook in VBA from a userform. The userform is displayed to the user whenever the workbook opens.

PROBLEM:
To put it simply, when I use:

ActiveWorkbook.Close savechanges:=False
the workbook closes as expected. However, when I open that workbook it's as if it hasn't closed completely as the workbook open event doesn't fire.

I checked the active processors and it seems that the instance of the Excel application is still running as a background process.

If I use:

Application.Quit
This does complete close the workbook, however, all opened workbooks are also closed, so this isn't really an option unless I want irate users banging down my door complaining about losing their work

Thanks in advance.