Hello.

I have a worksheet that the Workbook_Open event to load a
userform. The code is:

Private Sub Workbook_Open()
Load UserForm1
UserForm1.Show
ActiveWorkbook.Close SaveChanges:=False
End Sub

When the user exits UserForm1, control passes back to
workbook_open macro, and the workbook is closed.

When I open the worksheet for the first time, everything
works fine. However, when I exit via the above code, and
then reopen the worksheet, I get the following VB errors:

"Path/File Access Error", and
"Run-Time Error 75, Cannot find the specified object"

When I hit the DEBUG button, the "Load Userform1" is
highlighted (see code, above). Apparently, it cannot
find UserForm1. Also, when this error occurs, the
Project Explorer window appears blank -- nothing is in
it.

If I hit END in the Error box, Excel crashes.

This worksheet and macro was originally designed in Excel
97, and it ran fine. Now, I'm using Excel 2002 with
Windows XP. I recently installed an update for Excel,
but the problem still exists.

Does anyone know what is going on?

Thanks!

-Jon