Workbook open to the same sheet

[Guest]

I'd like to know how to open the the same sheet of the workbook, regardless
of at which sheet it was save last.
Thx.
cg

 

[JE McGimpsey]

One way:

Put this in the ThisWorkbook module of the workbook:

Private Sub Workbook_Open()
Sheet1.Activate
End Sub

Where Sheet1 is the code name of the sheet you want to open.

 

[Guest]

Did try on a module but not work!

How do I get to the ThisWorkbook module from
Tools
Macro
Visual Basic Editor
Thx.
cg

 

[JE McGimpsey]

See

http://www.mcgimpsey.com/excel/modules.html

 

[Guest]

I found it. Yes. It does work.
Thanks, JE McGimpsey.
cg