Thanks Joel, I will give that a try when I get back to work.

"joel" wrote in message
...

I think I can tell you what happens. Not sure if it will help solve
the problem.

When you open a Userform you initialize a Class which also adds events
to the windows event table for the class like an Terminate event. if
you don't override an event the standard event handler is called.

You created an overide event for the Terminate Event which is not doing
everything the standard terminate normally does. I think you have to
call the standard Terminate event after your terminate event finishes.

I think I found the problem. You named your Terminate function the
same name as the default terminate function and destroyed the default
terminate. Your terminate function name should be the name of the
userform like this

from
Private Sub UserForm_Terminate()
to
Private Sub UserForm1_Terminate()


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?u=229
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=203725

http://www.thecodecage.com/forumz