How can I completely close a specific workbook without closing other open workbooks

[Sc0ut]

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:

Please Login or Register  to view this content.

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:

Please Login or Register  to view this content.

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.

[BadlySpelledBuoy]

Is the active workbook you're trying to close the one that the userform is being run from?

Perhaps a sample workbook would make things clearer.

BSB

[Sc0ut]

Thanks for your reply.

Is the active workbook you're trying to close the one that the userform is being run from?

Yes.

Not a problem. I have attached it.

Here is what you need to do to reproduce the problem.
1. Open Book1.xlsm
2. Click the close button on the userform
3. A message box will offer a yes/no response. Click Yes to close the workbook.
4. Don't close the black excel window. Instead, open Book1.xlsm again. You should now see the problem - the workbook open event doesn't fire and the userform isn't displayed.

Cheers!

[Sc0ut]

When opening the workbook for the second time (without closing the Excel Application), the problem seems to be caused by the use of the Application.EnableEvents property:

Please Login or Register  to view this content.

If I remove that statement (Application.EnableEvents), the workbook open event fires and the userform is displayed.

Obviously this isn't a problem when opening the workbook for the first time.

#Confusing

[Sc0ut]

Moved to a new thread.