Closing workbook on closing the form

[nitind]

I have a form that is loaded when the workbook is opened.I want that when a user clicks on the close button on the form the workbook should get closed.How to do it

 

[shyrath]

Add below line to the code. Instead of activeworkbook you can also use the name of it.



ActiveWorkbook.Close

 

[nitind]

Add below line to the code. Instead of activeworkbook you can also use the name of it.



ActiveWorkbook.Close

But where should i write that code.I mean is there any event triggered when the close button is clicked on any form(well it must be), where to capture it

 

[westconn1]

Private Sub UserForm_Terminate()

 

[shyrath]

Sorry, in the form, add a button and in the button code put something like this

Private Sub CommandButton2_Click()
YourForm.Hide
ActiveWorkbook.Close
End Sub

 

[shyrath]

Private Sub UserForm_Terminate()

or that