Open Workbook on a specific Worksheet

[j10001]

Hi, I have a workbook in which one of two worksheets, 'Sheet1' and 'Sheet2', will be hidden at any one time, and the other is not hidden.
When the workbook opens if 'Sheet1' is hidden, I want the workbook to open on 'Sheet2'.
If, when the workbook opens, if 'Sheet2' is hidden, I want the workbook to open on 'Sheet1'.
If one worksheet is hidden the other will always not be hidden.
Could someone plese help me write a code that could do this, if it makes sense??
Thanks ....

 

[OfficeUser]

If I am understanding this right this will work. Place it in the ThisWorkbook module.

Private Sub Workbook_Open()
If Sheets("Sheet1").Visible = True Then
   Sheets("Sheet2").Visible = True
   Sheets("Sheet1").Visible = x1VeryHidden
Else
If Sheets("Sheet2").Visible = True Then
   Sheets("Sheet1").Visible = True
   Sheets("Sheet2").Visible = x1VeryHidden
End If
End If
End Sub

When you open the sheet and sheet 1 is visible, it will hide and sheet 2 will now be visible. If you open the sheet and sheet 2 is visible, it will hide and sheet 1 will be visible. Kinda like a toggle switch everytime you open the worksheet. You must always have one sheet unhidden, thus why I coded it the way I did. May be a better way, but it works for me.