| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Opening on a specific worksheet
Hi
I have a workbook with dozens of individually named sheets. Can I get Excel 2007 to open the workbook on the same sheet regardless of which sheet I was working on when I closed/saved the workbook? -- TIA Tim |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Opening on a specific worksheet
|
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Opening on a specific worksheet
"Tim" wrote: Hi I have a workbook with dozens of individually named sheets. Can I get Excel 2007 to open the workbook on the same sheet regardless of which sheet I was working on when I closed/saved the workbook? -- TIA Tim |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Opening on a specific worksheet
Don't know whats happening with my posts !
Open the VBA code page for ThisWorkbook and enter the following into the Workbook Open function Me.Sheets("YourSheetNameToOpen").Select "Tim" wrote: Hi I have a workbook with dozens of individually named sheets. Can I get Excel 2007 to open the workbook on the same sheet regardless of which sheet I was working on when I closed/saved the workbook? -- TIA Tim |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Opening a excel file to a specific worksheet. | Excel Discussion (Misc queries) | |||
| Opening specific worksheet from hyperlink more questions | Excel Discussion (Misc queries) | |||
| Opening Excel file on a specific worksheet | Excel Worksheet Functions | |||
| opening a worksheet at a specific point | New Users to Excel | |||
| Opening specific worksheet from hyperlink | Excel Discussion (Misc queries) | |||
Linear Mode
