Hyperlinks and opening any sheet a workbook

Is there any way to open a sheet in a workbook through a hyperlink. Eg. if
there are 3 sheet in a workbook and it was saved with the first sheet
displayed can you use a hyperlink to open sheet 2.

Thanks in advance

no
You could use VBA in the workbook's Open event so that it checks something
and switches to the relevent sheet...but that depends on the condition
eg save a text file in the same folder & give it th esheet name. the event
handler could read the filename & slect the sheet. or inside the textfile
write the sheet name etc etc

"Angelo Battistoni" wrote:

> Is there any way to open a sheet in a workbook through a hyperlink. Eg. if
> there are 3 sheet in a workbook and it was saved with the first sheet
> displayed can you use a hyperlink to open sheet 2.
>
> Thanks in advance
>
>
>

If you want Sheet2 to be the activesheet when the workbook is opened, you
can put code to do this in the Workbook_Open event.

Private Sub Workbook_Open()
thisworkbook.Worksheets("sheet2").Activate
End sub

This must be placed in the ThisWorkbook module of the project

if the user doesn't disable macros on opening or if macros are not disabled
by security settings, then this will activate sheet2 on opening.

See Chip Pearson's page for general information on using events
http://www.cpearson.com/excel/events.htm

--
Regards,
Tom Ogilvy

"Angelo Battistoni" <[email protected]> wrote in message
news:[email protected]...
> Is there any way to open a sheet in a workbook through a hyperlink. Eg. if
> there are 3 sheet in a workbook and it was saved with the first sheet
> displayed can you use a hyperlink to open sheet 2.
>
> Thanks in advance
>
>