Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Choosing which sheet opens
Is there any way I can choose which worksheet opens when I open a specific
workbook? I know it will open to the last sheet saved, but neither I nor anyone else who uses my workbook can ever remember to return to (for example) worksheet 1, before saving and closing. Can I not automatically set the worbook to open to worksheet 1 whenever I open it? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Choosing which sheet opens
You can use a macro:
Option Explicit sub Auto_Open() Application.goto thisworkbook.worksheets("sheet99").range("a1"), scroll:=true end sub Change the sheetname to what you want. If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm josephdmcc wrote: Is there any way I can choose which worksheet opens when I open a specific workbook? I know it will open to the last sheet saved, but neither I nor anyone else who uses my workbook can ever remember to return to (for example) worksheet 1, before saving and closing. Can I not automatically set the worbook to open to worksheet 1 whenever I open it? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to look up value in another Sheet based on criteria in first sheet. | Excel Worksheet Functions | |||
Finding and compiling list of cells containing data... | Excel Worksheet Functions | |||
lock tab in sheet 2 until cell in sheet one is completed | Excel Worksheet Functions | |||
Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel | |||
auto numbering an exel work book sheet everytime it opens or print | Excel Discussion (Misc queries) |