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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excell 2000 macro will not open file! 1
Excel Excel spreadsheets opening at top instead of bottom. 4
change default file open position for large shared spreadhseet 1
add personal template to the insert worksheet dialog box 2
First Click or Keystroke jumps you to the first sheet 1
45 seconds to open a file 3
force first page view 8
Excel Add-In and Dual Monitor Causing Read-Only 1

Back
Top