| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open workbook with the same sheet every time
Can someone provide me with the code I need for the following:
If, say, I've got three worksheets - 1, 2 and 3 - how do I get the workbook to open with sheet 2 every time? Thanks Ed |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open workbook with the same sheet every time
On Jul 15, 2:08 pm, cavasta wrote:
Can someone provide me with the code I need for the following: If, say, I've got three worksheets - 1, 2 and 3 - how do I get the workbook to open with sheet 2 every time? Thanks Ed Hi cavasta, go to you workbook's open even and write the following code. sheet2.activate bye, naweed |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open workbook with the same sheet every time
Thanks very much Naweed. That's just what I wanted.
Ed "User" wrote: Hi cavasta, go to you workbook's open even and write the following code. sheet2.activate bye, naweed |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Open Workbook at a certain time | Excel Worksheet Functions | |||
| Why does a Multi-sheet/user file open on sheet two every time? | Excel Discussion (Misc queries) | |||
| Able to open same excel workbook at the same time ! | Excel Programming | |||
| Search open sheets in workbook and insert into open sheet | Excel Discussion (Misc queries) | |||
| Open sheet once 1st time xl is open | Excel Programming | |||
Hybrid Mode
