how do I specify what page a spreadsheet opens up to? 1

[Mitsu]

How do I specify what page a spreadsheet opens up to?
It seems that Excel remembers the sheet that you last looked at and when opening the file again, it jumps to that page. I have a table of contents "page" that I want excel to jump to every time I open the file regardless of what page I looked at last.

That is my Quest!

Thanks in advance,
Mitsu

 

[VulcanJedi]

XL should remember what sheet was the active/current sheet from the last save, I don't think it'll 'remember' otherwise.

The code you want I think should be: (goto VB editor, click 'this workbook',

Private Sub Workbook_Open()

application.sheets("NAME OF YOUR TABLE of CONTENTS SHEET&quot.select

End Sub

 

[Mitsu]

Thank you Tranpkp,

That worked!

Mitsu

 

[VulcanJedi]

great, no problem, glad I could help! Please let me know if this helped/worked!