Hi Shariq,

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

Change Sheet1 to the sheet of interest.

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


"Shariq" wrote in message
...
I'd like to know if it is possibe to fix a certain sheet to be opened
always
on top, I mean I have (hyper)linked a worksheet with other sheets and
workbook, so when I close this book and click open again no matter which
ever
sheet was open, but it should always open a certain sheet of the book I
would
want to.