Blank Gray Excel

[Nine Zero]

Hello,

I have a userform that performs a few functions and on completion im running the following to close it

Unload Me
ThisWorkbook.Close False

Everything works fine.

Issue im having is, after it closes the workbook, there remains an excel screen open with just a gray background, no spreadsheet. All i have to do is close that as well.

Not too much harm but would like to know if there is way to prevent that from happening.

Thank You

 

[Joe4]

If you have another workbook open in the same session, it will show that. If you do not, it will show what you see (because Excel is still open, but there are no open workbooks).
If you want to close out of Excel altogether, use:

Application.Quit

 

[Nine Zero]

If you have another workbook open in the same session, it will show that. If you do not, it will show what you see (because Excel is still open, but there are no open workbooks).
If you want to close out of Excel altogether, use:

Application.Quit

If I do have other workbooks open, and i run my file and run the code given, will it close other workbooks as well, or just the one where the code is in?

EDIT: Just tried the code suggested and it still left that gray screen open

 

[Joe4]

If I do have other workbooks open

Are they open in OTHER Excel sessions, or the same Excel session?
What happened to these other workbooks when you ran your original code?

What happens if you try changing:

ThisWorkbook.Close False

to

[/FONT][/COLOR]ActiveWorkbook.Close False

 

[Nine Zero]

Are they open in OTHER Excel sessions, or the same Excel session?
What happened to these other workbooks when you ran your original code?

What happens if you try changing:

ThisWorkbook.Close False

to

ActiveWorkbook.Close False

Found my issue...
I was calling both the Unload.Me and the Application.Quit in the form itself. So when i Unload the form, the Application.Quit does not run.

I just remove the Unload.Me since technically closing the Application will take care of the form itself also

 

[Joe4]

I was calling both the Unload.Me and the Application.Quit in the form itself. So when i Unload the form, the Application.Quit does not run.

I just remove the Unload.Me since technically closing the Application will take care of the form itself also

Ah yes, that makes sense. If you are quitting Excel completely, there i no need to worry about closing the Form first.

 

[Nine Zero]

Ah yes, that makes sense. If you are quitting Excel completely, there i no need to worry about closing the Form first.

Lastly just to make sure, if i close the workbook where the form resides, the form also goes with it correct, regardless if there are other workbooks open

 

[Joe4]

Lastly just to make sure, if i close the workbook where the form resides, the form also goes with it correct, regardless if there are other workbooks open

Yes, because the Form is actually contained in the workbook that is being closed, it will go with it.

 

[Nine Zero]

Yes, because the Form is actually contained in the workbook that is being closed, it will go with it.

Perfect.

Thanks for your help

 

[Joe4]

You are welcome.