How do I open a workbook in a specific sheet

[PetterSn]

I want to open an excel- workbook and start directly in a specified sheet in
a workbook with 200 sheets. Is there a way to name the file so I know which
sheet is the active?

[Norman Jones]

Hi Petter,

Try:
'=============>>
Private Sub Workbook_Open()
Me.Sheets("Sheet1").Activate '<<==== CHANGE
End Sub
'<<=============

Change Sheet1 to the name of the required sheet.

This is workbook event code and should be pasted into the workbook's
ThisWorkbook module *not* a standard module or a sheet module):

Right-click the Excel icon on the worksheet
(or the icon to the left of the File menu if your workbook is maximised)
Select 'View Code' from the menu and paste the code.
Alt-F11 to return to Excel.

If you are not familiar with macros, you may wish to visit David McRitchie's
'Getting Started With Macros And User Defined Functions' at:

http://www.mvps.org/dmcritchie/excel/getstarted.htm


---
Regards,
Norman


"PetterSn" <PetterSn@discussions.microsoft.com> wrote in message
news:73E88175-95F2-4BD7-A18C-3C726C646D64@microsoft.com...
>I want to open an excel- workbook and start directly in a specified sheet
>in
> a workbook with 200 sheets. Is there a way to name the file so I know
> which
> sheet is the active?

[PetterSn]

What I want is to open different sheets every time, like a database. I have
informations from various objects in every sheet, and want an adress that
points to the sheet of interest. I want to link the workbook, with the 200
sheets, to a map that when clicked on a house, the worksheet with updated
information about that house is opened.

Norman Jones skrev:

> Hi Petter,
>
> Try:
> '=============>>
> Private Sub Workbook_Open()
> Me.Sheets("Sheet1").Activate '<<==== CHANGE
> End Sub
> '<<=============
>
> Change Sheet1 to the name of the required sheet.
>
> This is workbook event code and should be pasted into the workbook's
> ThisWorkbook module *not* a standard module or a sheet module):
>
> Right-click the Excel icon on the worksheet
> (or the icon to the left of the File menu if your workbook is maximised)
> Select 'View Code' from the menu and paste the code.
> Alt-F11 to return to Excel.
>
> If you are not familiar with macros, you may wish to visit David McRitchie's
> 'Getting Started With Macros And User Defined Functions' at:
>
> http://www.mvps.org/dmcritchie/excel/getstarted.htm
>
>
> ---
> Regards,
> Norman
>
>
> "PetterSn" <PetterSn@discussions.microsoft.com> wrote in message
> news:73E88175-95F2-4BD7-A18C-3C726C646D64@microsoft.com...
> >I want to open an excel- workbook and start directly in a specified sheet
> >in
> > a workbook with 200 sheets. Is there a way to name the file so I know
> > which
> > sheet is the active?
>
>
>

[Norman Jones]

Hi Petter,

As a starting point, see David McRitchies Table of Contents page at:

http://www.mvps.org/dmcritchie/excel/buildtoc.htm


---
Regards,
Norman



"PetterSn" <PetterSn@discussions.microsoft.com> wrote in message
news:DFAA52F1-BB13-4689-B719-64DED8E4AA97@microsoft.com...
> What I want is to open different sheets every time, like a database. I
> have
> informations from various objects in every sheet, and want an adress that
> points to the sheet of interest. I want to link the workbook, with the 200
> sheets, to a map that when clicked on a house, the worksheet with updated
> information about that house is opened.
>
> Norman Jones skrev:
>
>> Hi Petter,
>>
>> Try:
>> '=============>>
>> Private Sub Workbook_Open()
>> Me.Sheets("Sheet1").Activate '<<==== CHANGE
>> End Sub
>> '<<=============
>>
>> Change Sheet1 to the name of the required sheet.
>>
>> This is workbook event code and should be pasted into the workbook's
>> ThisWorkbook module *not* a standard module or a sheet module):
>>
>> Right-click the Excel icon on the worksheet
>> (or the icon to the left of the File menu if your workbook is maximised)
>> Select 'View Code' from the menu and paste the code.
>> Alt-F11 to return to Excel.
>>
>> If you are not familiar with macros, you may wish to visit David
>> McRitchie's
>> 'Getting Started With Macros And User Defined Functions' at:
>>
>> http://www.mvps.org/dmcritchie/excel/getstarted.htm
>>
>>
>> ---
>> Regards,
>> Norman
>>
>>
>> "PetterSn" <PetterSn@discussions.microsoft.com> wrote in message
>> news:73E88175-95F2-4BD7-A18C-3C726C646D64@microsoft.com...
>> >I want to open an excel- workbook and start directly in a specified
>> >sheet
>> >in
>> > a workbook with 200 sheets. Is there a way to name the file so I know
>> > which
>> > sheet is the active?
>>
>>
>>