open to specific sheet If I open the workbook

[MartinL]

Hi Guys

I have a work book with about 70 hidden sheets in it and there is 1 maintenance sheet, that I need to update from time to time

What I want to be able to do is when I open this workbook it chacks for me "martin.lucas" and if that is true it unhides and opens "Sheet 2"

I'm guessing the code has to go in "This Workbook"
and the code starts

Private Sub Workbook_Open()
 
.....What goes here....
 
Sheets("Maintenance").Visible = True
Sheets("Maintenance").Select
 
End Sub

other than that I'm stumped

 

[Weaver]

if application.username = "martin.lucas" then ...

 

[GTO]

Is martin.lucas your username in Excel at home, or your name on a network?

 

[MartinL]

martin.lucas is my network name at work

Thanks tho Weavers solution works just fine