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" wrote in message
...
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