Patience
Active Member
- Joined
- Mar 30, 2006
- Messages
- 275
Hey all, little question - I have this : (Nice and easy)
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:
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.
Code:
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.
Last edited: