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.