Userform vbmodeless

[zplugger]

Running a workbook that is a add-in, if I make the add-in userform vbmodeless the workbook won't close?

Please Login or Register  to view this content.

Do I need to add something to add-in workbook before close event?
Thanks

[dominicb]

Good afternoon zplugger

You can't close a workbook and leave a userform open.
Is it the add-in you are trying to close? If so, it sounds like you haven't set your ThisWorkbook object property "IsAddIn" to True.

HTH

DominicB

[zplugger]

Thanks dominib
if I add a command button to userform to close it it works UnLoad Me, but if I close the userform with red X I get problems. How can I make the red X act the same way as a Commandbutton?

Please Login or Register  to view this content.

[dominicb]

Hi zpliugger

if I make the add-in userform vbmodeless the workbook won't close?

The workbook won't close or the userform won't close?
What kind of problems do you get?

DominicB

[zplugger]

The blank workbook wont close if I open the add-in workbook. If I close the add-in workbook with the commandbutton all is OK,but if I
close the add-in with the red x on the userform the blank workbook does not close. Just get a little blue circle turning.

[dominicb]

Hi zplugger

I have never had any issues closing a userform, modeless or otherwise.
I admit to being a little perplexed about why you are using a UserForm_QueryClose sub. I normally find that the little red X tidies up very nicely after itself and doesn't need any help - I would only use this structure if I wanted to intercept before the form closes, for example to give a message, or even stop the user from closing with the red X. What happens if you omit this routine?

DominicB

[zplugger]

Same problem with omited. dominicb this only happens when running as a Excel Add-In.No problem when its a normal workbook.