Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
open excel
CAN YOU OPEN A WORKBOOK WITH DIFFERENT WORKSHEET ACTIVE??
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CSV formatted files open odly in Excel 2000 | Excel Discussion (Misc queries) | |||
Unable to open excel document across a network. | Excel Discussion (Misc queries) | |||
Open an existing excel speadsheet, opens Excel but not the file?? | Excel Discussion (Misc queries) | |||
How do i open excel doc in works? | Excel Discussion (Misc queries) | |||
External Links on open and Excel 2003 | Excel Discussion (Misc queries) |