| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
excel will not open in right worksheet
When I open one of my workbooks with multiple spreadsheets, it opens to the
last sheet I had open, then switches to the sheet beside it. How can I get it to open and stay on the last sheet I had open? -- bf |
|
#2
|
|||
|
|||
|
bf
Perhaps you have some event code in ThisWorkbook that switches sheets? Hit ALT + F11 to get to the VB Editor. Select your workbook/project and expand Microsoft Excel Objects. Double-click on ThisWorkbook. Any code in there? Gord Dibben Excel MVP On Mon, 11 Apr 2005 15:10:02 -0700, "bf" wrote: When I open one of my workbooks with multiple spreadsheets, it opens to the last sheet I had open, then switches to the sheet beside it. How can I get it to open and stay on the last sheet I had open? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I open a specific worksheet using windows exp... | Excel Discussion (Misc queries) | |||
| How do I open an Excel worksheet in a new window? | Excel Discussion (Misc queries) | |||
| make an excel worksheet (sheet 2) open w/ the cursor located in t. | Excel Discussion (Misc queries) | |||
| Create New Microsoft Excel Worksheet Has 3 Sheets | Setting up and Configuration of Excel | |||
| how do i open Excel program without loading a new worksheet? | Excel Discussion (Misc queries) | |||
Linear Mode
