Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Starting a MS Excel workbook with a particular worksheet
When I open a workbook, it always does with SHEET 1. How do I start it with a
worksheet other than SHEET 1? I think it is useful when renaming the worksheets. Thanks |
#2
|
|||
|
|||
If you want to select sheet3 then use this code in Workbook Open() module
Sheets("Sheet3").Select Change the sheet3 to whatever sheet name you want to be selected first, while the workbook is opened. "IGA" wrote: When I open a workbook, it always does with SHEET 1. How do I start it with a worksheet other than SHEET 1? I think it is useful when renaming the worksheets. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why does Excel 2003 freeze when saving a workbook that has importe | Excel Worksheet Functions | |||
Starting MS Excel with a worksheet other than SHEET 1 | Excel Worksheet Functions | |||
link Access workbook to Excel workbook | Excel Discussion (Misc queries) | |||
Can't open workbook (in Excel 2000) | Excel Discussion (Misc queries) | |||
excel workbook | Excel Worksheet Functions |