J
Jon
Hello.
I have a worksheet that uses 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
the 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
I have a worksheet that uses 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
the 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