Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Why does a Multi-sheet/user file open on sheet two every time?

We have a multi-sheet file that is updated by several folks. Every time I
open the file it starts on sheet two. I have tried to figure out why this
is.. Want to change the default starting position to sheet one at the top but
have not been successful in finding that in the help files.

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Why does a Multi-sheet/user file open on sheet two every time?

Excel will open to the same location as the last save--unless you do something
special.

One of the special things you can do is have a macro that controls where you
want to go.

Option Explicit
Sub Auto_Open()
application.goto thisworkbook.worksheets("SheetNameHere").range("a1 "), _
scroll:=true
End sub

If you're new to macros:

Debra Dalgleish has some notes how to implement macros he
http://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm

(General, Regular and Standard modules all describe the same thing.)

Frustrated in NJ wrote:

We have a multi-sheet file that is updated by several folks. Every time I
open the file it starts on sheet two. I have tried to figure out why this
is.. Want to change the default starting position to sheet one at the top but
have not been successful in finding that in the help files.


--

Dave Peterson
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
Open WB on spesific sheet each time (Excel 2003) Espen Rostad[_2_] Excel Discussion (Misc queries) 3 November 11th 09 12:24 PM
In-sheet link to open file not working Mel[_4_] Excel Discussion (Misc queries) 0 October 2nd 09 01:05 AM
hide sheet on file open Hein Excel Discussion (Misc queries) 6 October 21st 08 11:00 PM
how can I open an excel file everytime on certain sheet? Inas Excel Discussion (Misc queries) 1 June 7th 07 12:28 PM
Time to open spread sheet STS Excel Discussion (Misc queries) 4 December 21st 06 08:54 PM


All times are GMT +1. The time now is 12:25 AM.

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

About Us

"It's about Microsoft Excel"