Showing modal Form from Modeless form

[PetLahev]

Hi

does anybody know why a modal form, that is shown from modeless form, will close the modeless form (parent)?

I use a modeless form to allow user continue working on a sheet but when they click on a button on the modeless form a new modal form is displayed, then when the modal form is closed and code returns into the modeless form, the modeless form will be closed (without QueryClose or Terminate events) when the code reaches end of the calling routine.

I treat with the modal form as a class, may it be problem?
Look at the example.

I don't have any idea why it doesn't working right now ...
Thanks a lot

Excel 2007 EN, Windows XP

 

[xenou]

You form works as expected for me (using XL2010 on XP SP3) ... the modeless form remains open when the modal form closes.

ξ

 

[PetLahev]

hmmm when I was creating the example I had open my real project. Now, when I'm testing the example once again and my real project is closed it works as you wrote.
ok, so the bug is somewhere in my project, I will find it and kill it
Thanks for your time