startup sheet?

  • Thread starter Thread starter Johnnyjomp
  • Start date Start date
J

Johnnyjomp

Hi there...
Is there a way to select which sheet will be displayed when a workbook
is opened? There does not seem to be any rhyme or reason to this.
TIA!
John
 
As far as I know it will open up to whatever sheet was open when last saved.
(And thats what happened when I did a little test just now.)
 
Johnnyjomp said:
Is there a way to select which sheet will be displayed
when a workbook is opened ?
Click to expand...

If we want it to open always with say, Sheet1's A1 selected,
we could tinker with this ..

Right-click on the Excel icon* > View Code
*icon just to the left of "File" on the main menu bar
(Above will bring us direct into the "ThisWorkbook" code window)

Then copy > paste the code below into the code window

'----
Private Sub Workbook_Open()
Sheets("Sheet1").Select
Range("A1").Select
End Sub
'----

Press Alt+Q to get back to Excel. Save the file after typing something in a
cell on another sheet (other than Sheet1), close and exit. Test it out by
re-opening the file. It should open in Sheet1's A1.


---
 
Back
Top