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...
 
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

Excel, assign cells in multiple worksheets from one sheet 1
Creating Useable Index 4
Merge Multiple workbook sheets into one workbook 0
Uisng the Max and Index function to link to other workbooks 1
Open Index Page 1
Excel Is this possible?? 3
Open at same sheet everytime 2
Excel shortcut options 0

Back
Top