Message box on workbook close

[zplugger]

How can I prevent a workbook closing if a userform is not close?.I know it will close on exit but it creates problem with the workbook syncing with dropbox.If the userform is closed before hitting the X there is no problem,if you hit the X with userform open dropbox gives you a vbaproject password box.This only happens if workbook has vba password.Have three sheets in workbook with a userform on each one,
worksheet1 userform2
worksheet2 userform3
worksheet3 userform4
Need a way to not close workbook if one of these userform are open?
I did put unload userform2 in the before workbook close and it does close the userform but still have problems with dropbox,the userform form need closed before you click on the X

Thanks for any input on this

[zplugger]

Is this going to be possible,or should I think of a different way.
Thanks

[LJMetzger]

Hi Larry,

Try the attached sample workbook that includes the following code. The workbook is not allowed to close if a UserForm is open.

If you can open the UserForm in Modal mode, Excel is locked out when the UserForm is open. This prevents the 'X' from being accessed.

Ordinary Module (e.g. Module 1) code:

Please Login or Register  to view this content.

ThisWorkbook module code:

Please Login or Register  to view this content.

UserForm1 code:

Please Login or Register  to view this content.

Lewis

[zplugger]

Thank you very much,just what I was looking for.