Not able to close the workbook as desired

Hi guys

I am getting a strange problem in closing my project when I click on Save & Exit button . As I think workbookbeforeclose event is called when I click on this button and so it opens the form again. Please find attached a copy of the form.

Could anyone please solve my problem as its very urgent to resolve.
Regards
Aman

Your code calls the userform before save, so when you click save & exit on the form the code closes the workbook which means that the before-close event displays the userform again

not sure what you expect it to do.

If you click on the X on the worksheet, the workbook closes so the form is no longer available.

Hi aman

i think ur problem is with workbook close event.

Raj

Originally Posted by aman1234

Hi Roy

That was my colleague who posted the same workbook to you. We are not able to resolve this problem so everyone is posting the things to get the right answer.

Actually, When you run the file and click on View MI report then workbook opens and when you press the X button then form is displayed. That works fine. My problem is with Save & exit button which doesn't work appropriately.
As workbook_beforeclose event executes before this and so on first click on this button the form doesn't close.

Hope you understand my problem.
Regards
Aman

You've asked the same question - what is going off here? This is potentially wasting member's valuable time!