| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
i want excel to show the first tab upon opening, not the second
when i open my spreadsheet, it always opens with the second sheet prominent, rather than the first. how can i change this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
i want excel to show the first tab upon opening, not the second
Hi,
You will need VB for that. Alt+F11 to open VB editor. Double click 'ThisWorkbook' and paste the code below in on the right. For it to work you must enable macros on opening Private Sub Workbook_Open() Application.Goto Sheets(2).Range("A1") End Sub -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "robsc" wrote: when i open my spreadsheet, it always opens with the second sheet prominent, rather than the first. how can i change this? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
i want excel to show the first tab upon opening, not the second
I assume mikes intention was to type: Sheets(1)
Beside that - if you'll save your WB while sheet(1) is in focus - that sheet will be shown the next time you open that WB. Micky "robsc" wrote: when i open my spreadsheet, it always opens with the second sheet prominent, rather than the first. how can i change this? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
i want excel to show the first tab upon opening, not the secon
Hmm,
Actually no I intended to write sheets(2) but that's because I misread the post!! Thanks for the correction. -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "מיכאל (מיקי) אבידן" wrote: I assume mikes intention was to type: Sheets(1) Beside that - if you'll save your WB while sheet(1) is in focus - that sheet will be shown the next time you open that WB. Micky "robsc" wrote: when i open my spreadsheet, it always opens with the second sheet prominent, rather than the first. how can i change this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for having next number show when opening file | Excel Discussion (Misc queries) | |||
| show most recent files first when opening excel files | Excel Discussion (Misc queries) | |||
| SHow user form when opening workbook | Excel Discussion (Misc queries) | |||
| Why do macros show up while opening document, but were deleted? | Excel Discussion (Misc queries) | |||
| REF errors when opening excel in xp. works fine when opening wor. | Excel Discussion (Misc queries) | |||
Linear Mode
