Hyperlink Navigation
 

Hello all.

My current order system requires navigation between various workbooks and
worksheets within these. My Navigation between sheets in the same book is via
simple macros, between workbooks it is via hyperlinks. My question is this,
is there any way so that when i click a hyperlink to take me to an open
workbook, it will take me to a specific worksheet? I have to use a hyperlink
and not a macro because of my system requirements. Each workbook has a menu
worksheet but if i have been working on a different sheet previously my
hyperlink takes me to that sheet, whereas i would rather go to the menu
sheet. Hope that didnt confuse you too much!