software

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.

Hi Shariq,

Try:
'=============gt;gt;
Private Sub Workbook_Open()
Me.Sheets(quot;Sheet1quot;).Activate
End Sub
'lt;lt;=============

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:

www.mvps.org/dmcritchie/excel/getstarted.htm---
Regards,
Normanquot;Shariqquot; gt; wrote in message
...
gt; I'd like to know if it is possibe to fix a certain sheet to be opened
gt; always
gt; on top, I mean I have (hyper)linked a worksheet with other sheets and
gt; workbook, so when I close this book and click open again no matter which
gt; ever
gt; sheet was open, but it should always open a certain sheet of the book I
gt; would
gt; want to.
Hi Norman,

Thanx 4 looking 2 my query, I M not sure if I've got my question right,
well, here it is again I'm working with several books each book containing
several sheets linked with each other, but certain book which is sort of a
main board or a menu has also some other sheets, I know if I only leave one
sheet in this book it will automatically open this only sheet, but what do I
have to do in order to make it work, that whenever I open this book it should
always show that sheet having hyperlinks to other books and sheets,

I'd appreciate a lot if you could help me out with this, and shell be
waiting for your response.

Regards Shariq,quot;Norman Jonesquot; wrote:

gt; Hi Shariq,
gt;
gt; Try:
gt; '=============gt;gt;
gt; Private Sub Workbook_Open()
gt; Me.Sheets(quot;Sheet1quot;).Activate
gt; End Sub
gt; 'lt;lt;=============
gt;
gt; Change Sheet1 to the sheet of interest.
gt;
gt; This is workbook event code and should be pasted into the workbook's
gt; ThisWorkbook module *not* a standard module or a sheet module):
gt;
gt; Right-click the Excel icon on the worksheet
gt; (or the icon to the left of the File menu if your workbook is maximised)
gt; Select 'View Code' from the menu and paste the code.
gt; Alt-F11 to return to Excel.
gt;
gt; If you are not familiar with macros, you may wish to visit David McRitchie's
gt; 'Getting Started With Macros And User Defined Functions' at:
gt;
gt; www.mvps.org/dmcritchie/excel/getstarted.htm
gt;
gt;
gt; ---
gt; Regards,
gt; Norman
gt;
gt;
gt; quot;Shariqquot; gt; wrote in message
gt; ...
gt; gt; I'd like to know if it is possibe to fix a certain sheet to be opened
gt; gt; always
gt; gt; on top, I mean I have (hyper)linked a worksheet with other sheets and
gt; gt; workbook, so when I close this book and click open again no matter which
gt; gt; ever
gt; gt; sheet was open, but it should always open a certain sheet of the book I
gt; gt; would
gt; gt; want to.
gt;
gt;
gt;

Hi Shariq,

My original suggestion stands.

Follow the previous instructions and paste the suggested code into the
ThisWorkbook module of the menu workbook. Then save and re-open the
workbook.---
Regards,
Norman
quot;Shariqquot; gt; wrote in message
...
gt; Hi Norman,
gt;
gt; Thanx 4 looking 2 my query, I M not sure if I've got my question right,
gt; well, here it is again I'm working with several books each book containing
gt; several sheets linked with each other, but certain book which is sort of a
gt; main board or a menu has also some other sheets, I know if I only leave
gt; one
gt; sheet in this book it will automatically open this only sheet, but what do
gt; I
gt; have to do in order to make it work, that whenever I open this book it
gt; should
gt; always show that sheet having hyperlinks to other books and sheets,
gt;
gt; I'd appreciate a lot if you could help me out with this, and shell be
gt; waiting for your response.
gt;
gt; Regards Shariq,
gt;
gt;
gt; quot;Norman Jonesquot; wrote:
gt;
gt;gt; Hi Shariq,
gt;gt;
gt;gt; Try:
gt;gt; '=============gt;gt;
gt;gt; Private Sub Workbook_Open()
gt;gt; Me.Sheets(quot;Sheet1quot;).Activate
gt;gt; End Sub
gt;gt; 'lt;lt;=============
gt;gt;
gt;gt; Change Sheet1 to the sheet of interest.
gt;gt;
gt;gt; This is workbook event code and should be pasted into the workbook's
gt;gt; ThisWorkbook module *not* a standard module or a sheet module):
gt;gt;
gt;gt; Right-click the Excel icon on the worksheet
gt;gt; (or the icon to the left of the File menu if your workbook is maximised)
gt;gt; Select 'View Code' from the menu and paste the code.
gt;gt; Alt-F11 to return to Excel.
gt;gt;
gt;gt; If you are not familiar with macros, you may wish to visit David
gt;gt; McRitchie's
gt;gt; 'Getting Started With Macros And User Defined Functions' at:
gt;gt;
gt;gt; www.mvps.org/dmcritchie/excel/getstarted.htm
gt;gt;
gt;gt;
gt;gt; ---
gt;gt; Regards,
gt;gt; Norman
gt;gt;
gt;gt;
gt;gt; quot;Shariqquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; I'd like to know if it is possibe to fix a certain sheet to be opened
gt;gt; gt; always
gt;gt; gt; on top, I mean I have (hyper)linked a worksheet with other sheets and
gt;gt; gt; workbook, so when I close this book and click open again no matter
gt;gt; gt; which
gt;gt; gt; ever
gt;gt; gt; sheet was open, but it should always open a certain sheet of the book I
gt;gt; gt; would
gt;gt; gt; want to.
gt;gt;
gt;gt;
gt;gt;