close
CAN YOU OPEN A WORKBOOK WITH DIFFERENT WORKSHEET ACTIVE??
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(quot;sheet99quot;).select
end sub
If you're new to macros, you may want to read David McRitchie's intro at:
www.mvps.org/dmcritchie/excel/getstarted.htm
100pinesfarm wrote:
gt;
gt; CAN YOU OPEN A WORKBOOK WITH DIFFERENT WORKSHEET ACTIVE??
--
Dave Peterson
全站熱搜
留言列表
