Try checking if the first file is already open, then YOU
don't do the workbook_open event

like this
on error resume next
dim nms as string
nms=""
nms=workbooks("MyfirstFile.xls").name
if nms="" then
' This section is for your actual code on
' the Workbook_open event
end if


Francisco Mariscal
fcomariscal at hotmail dot com

-----Original Message-----
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
.