Unload userform help

[andyt2005]

Morning all, Im trying to get a workbook to close when the user clicks the 'x' on the userform which i can do no issues, The issue lies in another command i use to unload the userform. Im sure you can all guess what happens Is there any way around this? ATM when the user clicks the 'x' it checks to see if any other workbooks are open and if not it quits excel but if there are other workbooks open it closes the workbook containing the userform but leaves the others open.Any ideas or help?

 

[DeezNuts]

this work for you:

ActiveWorkbook.Close True

closed only my active one even when the X is clicked

 

[Norie]

What is the issue?

 

[andyt2005]

no joy So baisically i have user form load up on start, and an option to 'login'i want it so that if the user clicks the 'X' then it will close/quit. However if a user logs in i just want the user form to 'unload' this is where it goes wrong, when the form unloads it closes/quits the workbook because the user form has been terminated

 

[royUK]

Have you tried setting a boolean "flag"? See this example

 

[andyt2005]

Have you tried setting a boolean "flag"? See this example

Perfect!! Thanks