Solved: Unable to close excel

Hi Friends,

I have a vba project and whenever I run that for longer time it doesn't close the excel by pressing 'X' on top and for some user it asks for password when they close from exit excel in menu. Please help how can I solve this issue.

Thanks.

One way that would happen would be if the Close event for ThisWorkbook object was programmed to do that.

Thanks a lot Kenneth, this was a good work around worked successfully. I hope this works fine for other users as well.