Object Variable or With block variable not set

[Eric Carolus]

Hi folks
I used the following code in a project and every time it comes back with:
Run-time error 91
Object Variable or With block variable not set

Private Sub Workbook_Open()

Application.ScreenUpdating = False

    ActiveWindow.Visible = False

    SplashUserForm.Show

    Windows(ThisWorkbook.Name).Visible = True



' WORKBOOK OPEN WITH/AT SHEET "Information"

    Sheets("School Information").Select

    Application.ScreenUpdating = True

End Sub

I have searched the forum and found numerous solutions,
but I still cannot nail it.

What am I doing wrong?
Please help.

Crow

 

[RoryA]

Which line is highlighted by the debugger? Do you have a userform called SplashUserform in that workbook?

 

[Eric Carolus]

Hi RoryA

The highlighted line is:

Windows(ThisWorkbook.Name).Visible = True

And Yes I have a user form called SpalshUserform in the workbook.

Thanks in advance.

Crow

 

[RoryA]

So this is after you close the userform? Or are you showing the form modelessly?

 

[Eric Carolus]

Hi RoryA

The form (Splash Screen) is on a timer and not even Excel
is shown until the Splash screen is unloaded.

I sometimes also get the message
Subscript out of range
Run-time error 9

Thanks in advance.

Crow