Excel will remember the worksheet that was active when you last saved. So you
could always save from the worksheet you want active (right before you close the
workbook).
Or you could use a macro that would select the worksheet that you want when you
open the workbook:
Option Explicit
sub auto_open()
worksheets("sheet99").select
end sub
If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
