Close the workbook when the user form is closed

[sanrv1f]

Hi

Im using an user form to design a calculator

once the user closes the form, I want the work book also to get closed without asking the user to save changes

here is the code I used

Private Sub UserForm_Terminate()

ThisWorkbook.Close savechanges:=False
End Sub

this code works fine and closes the excel without prompting for saving, but excel hangs after that, pls help me with this

 

[VoG]

If you mean that you want to exit Excel as well try

Private Sub UserForm_Terminate()
ThisWorkbook.Close savechanges:=False
Application.Quit
End Sub

 

[Norie]

Sankar

'Hangs' in what way?

Perhaps this is what you want.

Application.Quit

 

[sanrv1f]

Hi

"Hangs" means the cursor changes to hour-glass and nothing happens thereafter, if there is no other workbooks are open,
if there is someother workbook open, then excel closes and generates an error report,

I dont want to quit the application, I just want the current workbook to close without saving, along with the form and, other open workbooks need remain open,

Also tell me, is there any way to open a workbook exclusively under an application and any other workbook the user opens to open under a different application