Non-VBA method to open a workbook to a selected sheet?

[Lostguy]

Hello!

Any way to set it so that when you open a workbook, it always opens to
the same sheet? Can this be done without VBA/macros?

Thanks!

VR/

Lost

 

[Harlan Grove]

Any way to set it so that when you open a workbook, it always opens to
the same sheet? Can this be done without VBA/macros?

No, not reliably.

 

[Dave Peterson]

Always save it with the sheet you want active the next time you open the
workbook.

It'll be as reliable as your ability to remember to do this.

 

[Gord Dibben]

Hide all other sheets.


Gord Dibben MS Excel MVP