Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 7th 05, 06:17 PM
Excelfrustrated
 
Posts: n/a
Default 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!

  #2   Report Post  
Old February 7th 05, 08:12 PM
Bernard Liengme
 
Posts: n/a
Default

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" wrote in
message ...
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!



  #3   Report Post  
Old February 7th 05, 09:15 PM
Gord Dibben
 
Posts: n/a
Default

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
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!




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
sharing/using/saving Excel 2002 files in Excel 2003 maze2009 Excel Discussion (Misc queries) 0 January 20th 05 08:27 PM
Can excel automatically number itself each time you open a documen Alesha Excel Discussion (Misc queries) 1 January 11th 05 08:40 PM
how to open and see 2 excel work sheets at a time cwm Excel Discussion (Misc queries) 3 December 26th 04 02:27 PM
Macro in Excel 2002 to save a workbook to a FTP location Lloyd Excel Discussion (Misc queries) 0 December 21st 04 03:49 PM
How do I open each workbook in it's own version of Excel? RKOCT Excel Discussion (Misc queries) 3 December 9th 04 12:32 AM


All times are GMT +1. The time now is 02:49 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017