Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
open to a certain sheet tab in a different workbook | New Users to Excel | |||
How can I set a workbook to open always with a certain sheet I wan | Setting up and Configuration of Excel | |||
Search open sheets in workbook and insert into open sheet | Excel Discussion (Misc queries) | |||
Open workbook at a particular sheet | New Users to Excel | |||
open sheet on workbook open | Excel Programming |