View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
hccatmo hccatmo is offline
external usenet poster
 
Posts: 15
Default 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