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
|