open excel
 

CAN YOU OPEN A WORKBOOK WITH DIFFERENT WORKSHEET ACTIVE??

open excel
 

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

100pinesfarm wrote:

CAN YOU OPEN A WORKBOOK WITH DIFFERENT WORKSHEET ACTIVE??

--

Dave Peterson