Much like this question but I want to be able to insert a Hyperlink into one sheet that opens another sheet in a new window.
P.S. Using Excel 2007
First you must do what is said in the question I linked to to make normal sheets open in separate windows. Then you can use:
=HYPERLINK("excel /e '\\Path\File.xlsx'","Open the file")