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

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

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

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.


"robsc" wrote:


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

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

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



"robsc" wrote:


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

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

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.


"מיכאל (מיקי) אבידן" wrote:

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



"robsc" wrote:


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