vba excel - close Excel instance from modal form keeps window open

Below is code to shut down (quit the excel instance) my project. There are two exit buttons to which the user can exit the project. One is within a form (modal) on a login screen. The other exit button is within a different form (modeless) within the project after login is achieved. The exit code from the modeless form closes the instance completely. Attempting to exit from the modal form closes the form, but the excel window remains open. The desire is for the excel instance to shut down completely. When I change the modal form to modeless, the excel instance shuts down properly. Why is this? What do I need to add to completely shut down the excel instance from a modal form using the below code?

Please Login or Register  to view this content.

Hiya, try unloading the form before workbook.close or application.quit?

Please Login or Register  to view this content.

Hello Poizhan,
thanks for the suggestion, but I already tried that. I also tried Hiding the form before the close or quit. That does not work either.

Thanks CK. A couple aspects to this.

If count>1 then project closes and Excel window for the workbook closes.

If count<1 then project closes but Excel window stays open.

.....nope.

I understand that it's discouraged to have the user form close or quit the application for many reasons. I've read a little about it through various posts, but have difficulty grasping implementation if entire ui is form driven.

Currently code that loads the form is executed on a Workbook_Open event and user cannot close the Excel document using Excel functions.

I thought by having the command call a module subroutine since that executes properly when forms are modeless.

Currently on the open event there is a timer sub. The sub is within ThisWorkbook. Should the timer sub be within a standard module then?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Forms unload and the clean up completes, but the excel instance still remains open.

Hmm, just tested code from post #4. Worked fine in my environment with multiple workbook or single workbook open.

There must be something in your project that's preventing Excel instance from closing completely. I'd suggest, commenting out sections etc, to pinpoint what exactly is interfering with Excel instance being closed. Then first terminate that process before attempting to close Excel instance.

idk. I've tried all the options including your suggestion CK76 and Excel still will not quit. I commented the If Then statement leaving just Application.Quit and the workbook window still remains open.

It seems fairly straight forward to me. I've stripped all the code down and even tried some snippets into the BeforeClose event. A MsgBox "test" fires, but ThisWorkbook.Close False OR Application.Quit still does not close the instance window.

I guess as long as the workbook cleans up and closes I may have to just live with this. Just strange that the window instance completely closes when other Excel files are open, but doesn't when it's the only file open.