Pamela,

The Application.Enableevents property migth do the trick. In your module
that's opening the second workbook try this:

Application.EnableEvents = False
Workbooks.Open "test1.xls"
Application.EnableEvents = True

However, this will disable all workbook_open events, so if you have others
that you do want to run this won't work.

hth

Doug


"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