i want excel to show the first tab upon opening, not the second

  • Thread starter Thread starter robsc
  • Start date Start date
R

robsc

when i open my spreadsheet, it always opens with the second sheet prominent,
rather than the first. how can i change this?
 
Hi,

You will need VB for that. Alt+F11 to open VB editor. Double click
'ThisWorkbook' and paste the code below in on the right. For it to work you
must enable macros on opening

Private Sub Workbook_Open()
Application.Goto Sheets(2).Range("A1")
End Sub
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
I assume mikes intention was to type: Sheets(1)
Beside that - if you'll save your WB while sheet(1) is in focus - that sheet
will be shown the next time you open that WB.
Micky
 
Hmm,

Actually no I intended to write sheets(2) but that's because I misread the
post!! Thanks for the correction.
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
Back
Top