Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 6th 05, 06:53 AM
TNT
 
Posts: n/a
Default How do I open to a specific worksheet every time?

I have a workbook with a large number of wooksheets, but I want to open to
the same one each time. I have closed the file while on this worksheet, but
it always opens to another one (about midway). I thought I used
tools/options in the past for this, but can't seem to find a way in Excel
2003 to accomplish this. Can anyone assist? Thank you.

  #2   Report Post  
Old February 6th 05, 07:01 AM
JulieD
 
Posts: n/a
Default

Hi

you can use a workbook_open macro to ensure that the same sheet is opened
every time

e.g.
Private Sub Workbook_Open()
Sheets("Index").Activate
Range("A1").Activate
End Sub

---
to use this code, right mouse click on any sheet tab and choose view code -
in the VBE window you should see the name of your workbook in bold on the
left (in brackets) - underneath it you should see things like Sheet1, Sheet2
etc and then ThisWorkbook - double click on ThisWorkbook and copy and paste
the code in there - changing Index to the name of the sheet you want
displayed on opening.

then press ALT & F11 to return to your workbook - close & save as normal.
When you open the workbook it should always go to the selected sheet. Note,
however, you might need to change your security settings under tools / macro
/ security to medium to enable macros to run.

Hope this helps
Cheers
JulieD

"TNT" wrote in message
...
I have a workbook with a large number of wooksheets, but I want to open to
the same one each time. I have closed the file while on this worksheet,
but
it always opens to another one (about midway). I thought I used
tools/options in the past for this, but can't seem to find a way in Excel
2003 to accomplish this. Can anyone assist? Thank you.



  #3   Report Post  
Old February 6th 05, 01:06 PM
Ken Wright
 
Posts: n/a
Default

Other than using code as Julie has suggested, you need to SAVE whilst on a
particular worksheet and then you can close it from anywhere. The sheet you
are opening up to automatically is the sheet you were on the last time the
book was saved.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"TNT" wrote in message
...
I have a workbook with a large number of wooksheets, but I want to open to
the same one each time. I have closed the file while on this worksheet,

but
it always opens to another one (about midway). I thought I used
tools/options in the past for this, but can't seem to find a way in Excel
2003 to accomplish this. Can anyone assist? Thank you.





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
Hyperlink to specific worksheet in Excel Glenn Mulno Links and Linking in Excel 2 February 7th 05 07:01 PM
How to open a workbook with a specific worksheet displayed by defa ThaiNB New Users to Excel 2 January 21st 05 07:11 AM
Weekly Transaction Processing Ralph Howarth Excel Worksheet Functions 4 January 19th 05 06:37 AM
How do I stop Excel from closing the open file each time I open a. Welsin Setting up and Configuration of Excel 3 January 9th 05 12:16 AM
How do I get my personal macro worksheet to open whenever I open . Claudia_R Excel Discussion (Misc queries) 3 December 10th 04 12:59 AM


All times are GMT +1. The time now is 07:13 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017