Any particular reason this works once but not twice?

[Patience]

Hey all, little question - I have this : (Nice and easy)

Private Sub Workbook_Open()

    If ActiveWindow.Visible = False Then
        
        Exit Sub
        
        Else
    
        ActiveWindow.Visible = False
        
    End If
    
    
End Sub

in two workbooks that are in the XLStart folder. One workbook opens fine and hides, (which I want) but the other (and always the same one) gives me this:

Run Time Error 91 Object Variable or With Variable not set

I assume that it doesn't like having two things doing the same thing. Is there a way round this - just to have two workbooks open and hide (or be hidden)? Thanks.




Edit - OK - I see that ActiveWorkbook is causing problems, but ThisWorkbook.Visible doesn't exist. **** I hate this.

 

[RoryA]

If you had no visible workbooks, would there be an activewindow?
Can't you just hide and save the workbooks? Then they will open hidden by default.

 

[Patience]

You see I have this disease. I means I have to try and make everything 10 times harder than it really needs to be.

Thank you Rory.

 

[RoryA]

I'm lucky - I'm a bit simple, so I tend to think that way!