Run Time Error 75

[Jon]

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

 

[Eric]

Jon I am having the exact same problem I have multiple users access a
spreadsheet and I they don't save the changes when finished. When they open
the sheet for the first time it works fine, however if they don't close excel
out completely and try to reopen the program they get runtime errors and
catastrophic failures. If i try to debug them half the time excel will crash.
I'm using multiple userforms in this spreadsheet as well.

I'm real interested in finding a solution to this as I'm sure you are!

Eric