Ron de Bruin and Mike,
Both of your methods are in vain. However, I use the excel file
in other MS office computer but the problem is gone. I suppose that's the
problem in Excel. Hence I re-install MS office in my computer, the problem
disappear.
Anyway, Thanks again for your prompt reply.
Kan
"Him_B" ¼¶¼g©ó¶l¥ó·s»D
...
Thanks Ron de Bruin and Mike,
I will try and tell you the result.
Kan
"Mike Fogleman" ¼¶¼g©ó¶l¥ó·s»D
...
Without seeing the code I would guess that a userform is still loaded
into
memory. Make sure all forms are Unloaded after they are hidden. If a
form
needs to remain loaded into memory so subsequent code can use its
properties
or values, then perhaps Unload the form in ThisWorkbook Before_Close
event.

Unload UserForm1

If this is not seemingly the problem, post your code for more help.
Mike

"Him_B" wrote in message
...
Dear those Excel Experts,

I have a problem related to the excel application
closing
problem. I have created a excel filewith 4 userforms, 4 worksheets and
some
Marco on it. If I close the file but not to quit the excel
application,
the
VBAProject are still been seen in the VBE. I open the file again in
this
circumstance, the Marco can not run properly. In other case, if I quit
the
excel application when I close the file, It will have no problem.
Can
anybody tell me why and how to solve it.
Many Thanks,
Kan