Excel VBA - Closing Entire Spreadsheet From UserForm

[Hack]

This is the first time I've ever used a UserForm with Excel (or actually done any coding in VBA for that matter).

I have a UserForm. When I close it, the underlying excel spreadsheet (which is completely blank and used for no other purpose than as a home for the userform) is still displayed on the screen and must be closed as well.

On the userform, I tried

Private Sub UserForm_Deactivate()
Workbooks.Close
End Sub

But that didn't do anything.

Can I cleanly close both when I shutdown the userform?

[Hack]

Never mind. I got it.

Application.Quit

[Ron Weller]

If you don't want to exit excel, just close the workbook then use:

ActiveWorkbook.Close
'..Or..
Workbooks(1).Close

Remember Workbooks is a collection so you need to specify which workbook, even if only one is open.

[Hack]

That is good to know, but I think in this instance, closing Excel would be the way to go.