Are you opening the workbook with frmSurvey manually, or through code? If
it's through code, have you tried disabling events (i.e.
application.enableevents = false) before you begin the process that causes
frmSurvey to display? Or even by copying from the second workbook without
making it active?

Not being able to close it may be because of your forms' modality -
whichever form is 'topmost' has the focus, and you can't close a form that's
not the topmost, unless all your forms are modeless (because you can't mix
modal & modeless forms)

HTH.


"P Cheek" wrote in message
om...
I have a workbook that I open automatically with a user form
(frmQuery)showing.
Upon opening the workbook in the initialization event, I have a second
workbook open in order to copy information from one to the other and
then close the second workbook. The second workbook also opens
automatically with a user form (frmSurvey).

The problem I have is I don't want the second workbook form
(frmSurvey) to show during the copy process. I can't seem to get it
to not show. I have tried the UNLOAD and the HIDE methods, neither of
which works.

Any suggestions?

PAM