Excel 2003 - How do I change which sheet in my workbook opens firs
If you save the workbook with the "correct" worksheet the active worksheet, then
excel remembers that the next time you open it.
If you don't want to do that, you can use a macro to select the sheet that you
want. This goes into a general module:
Option Explicit
Sub Auto_Open()
application.goto thisworkbook.worksheets("sheet9999").range("a1"), _
scroll:=true
End Sub
Change the sheet name to what you want.
ExtraLarge XL User wrote:
I have a multiple sheet Excel workbook that I reference often, but it opens
to a middle sheet, not to the first sheet like I want. Any ideas?
--
Dave Peterson
|