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

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?