How do I open a workbook in a specific sheet

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?
>
>
>

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?
>>
>>
>>