Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Opening an excel index sheet by default
How can I open by default the Index sheet on my ledger workbook. There are
fifteen named sheets as well as the Index sheet |
#2
|
|||
|
|||
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 -- tj "Bowtai" wrote: How can I open by default the Index sheet on my ledger workbook. There are fifteen named sheets as well as the Index sheet |
#3
|
|||
|
|||
Thanks. Both suggestions work fine.
"tjtjjtjt" wrote: 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 -- tj "Bowtai" wrote: How can I open by default the Index sheet on my ledger workbook. There are fifteen named sheets as well as the Index sheet |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Confusing Invisible Excel Sheet | Excel Discussion (Misc queries) | |||
Updating excel sheet with selected data from another sheet in the same file | Excel Worksheet Functions | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
Excel won't copy outside sheet | Excel Discussion (Misc queries) | |||
Hyperlink to specific sheet in Excel Web File | Links and Linking in Excel |