Opening an excel index sheet by default

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I open by default the Index sheet on my ledger workbook. There are
fifteen named sheets as well as the Index sheet
 
You could always click to the Index sheet and Save beofre you close the file.
Or, you can right-click on the Excel icon to the left of the file menu and
choose View Code.
Then, click on the drop-down that has the text "(General)" in it and choose
"Workbook."
Paste something like this in the middle of the empty Private Sub
Workbook_Open():
If ActiveSheet.Name <> "Index" Then
Sheets("Index").Activate
End If
 
Thanks. Both suggestions work fine.

tjtjjtjt said:
You could always click to the Index sheet and Save beofre you close the file.
Or, you can right-click on the Excel icon to the left of the file menu and
choose View Code.
Then, click on the drop-down that has the text "(General)" in it and choose
"Workbook."
Paste something like this in the middle of the empty Private Sub
Workbook_Open():
If ActiveSheet.Name <> "Index" Then
Sheets("Index").Activate
End If
Click to expand...
 
Back
Top