Hiding/Showing UserForms

[j_Southern]

The following subroutine :-

Please Login or Register  to view this content.

When this is called I get the message "Must close or hide topmost Modal form first" at the line marked ****
There are no other forms in use.
I am at a loss as to what to do next to resolve this matter and would welcome some advice.
John

[gmr4evr1]

I think it is because you are hiding userform2, all that does is make it "invisible". You might have to use unload for userform2 instead of hide.

[j_Southern]

Tom,
Thanks for your help.
Your idea allowed the code to work but caused some other difficulties down the line. There were controls on the forms that had been enabled and disenabled to help the user. Unfortunately when the forms were unloaded this information was lost and all the controls reverted to their initial condition.
In the end the problem was solved by turning all the forms non modal.
John

[gmr4evr1]

Sorry about the additional problems, but thanks for the explanation, it was helpful to me, and hopefully to others as well.