View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
P Cheek P Cheek is offline
external usenet poster
 
Posts: 3
Default Copy one spreadsheet into another without activating second spreadsheet's user form

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