Workbook open to the same sheet
 

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

Workbook open to the same sheet
 

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.

In article ,
hccatmo wrote:

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

Workbook open to the same sheet
 

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" wrote:

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.

In article ,
hccatmo wrote:

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

Workbook open to the same sheet
 

See

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

In article ,
hccatmo wrote:

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

Workbook open to the same sheet
 

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

"hccatmo" wrote:

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" wrote:

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.

In article ,
hccatmo wrote:

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