Thread: Why does Excel 2003 open on 3rd tab of workbook every time, not l.

I'm using Excel 2003, and every time I save the file, no matter what
worksheet I was last on, when reloading the file, it defaults to opening the
3rd worksheet, and places the focus on the same cell. I want it to open on
the last worksheet that was being viewed/used when the file was last saved,
like previous versions have always done!

And like 2003 does unless you have done something strange. We need more
details

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Excelfrustrated" <Excelfrustrated@discussions.microsoft.com> wrote in
message news:77AB36F8-4C5D-42DC-A763-00C8E12144D5@microsoft.com...
> I'm using Excel 2003, and every time I save the file, no matter what
> worksheet I was last on, when reloading the file, it defaults to opening
> the
> 3rd worksheet, and places the focus on the same cell. I want it to open
> on
> the last worksheet that was being viewed/used when the file was last
> saved,
> like previous versions have always done!

Sounds like you have some VBA code running when you save or close the
workbook.

Right-click on the Excel logo next to "File" on menu bar. Or right-click on
the logo at top left of window if not running maximized.

Select "View Code" to see what you have in there.

You could delete or REM(')out the lines you don't like or need.


Gord Dibben Excel MVP

On Mon, 7 Feb 2005 09:17:02 -0800, Excelfrustrated
<Excelfrustrated@discussions.microsoft.com> wrote:

>I'm using Excel 2003, and every time I save the file, no matter what
>worksheet I was last on, when reloading the file, it defaults to opening the
>3rd worksheet, and places the focus on the same cell. I want it to open on
>the last worksheet that was being viewed/used when the file was last saved,
>like previous versions have always done!