Changing the right window in a split window based on clicking on hyperlink in the left win

I have also posted this question in this forum:

http://www.mrexcel.com/forum/excel-q...ml#post3571063

I got this question from a friend of mine.

In my workbook I have the first sheet (main sheet) containing the names of all my students with hyperlinks to individual student sheets. The following sheets are the individual sheets for each student.

In my working window I want to see both my main sheet at the left side of the screen and the student sheet that I have chosen on the right side of the screen as a split window.

If I click on a hyperlink (student name sheet) in my main sheet I want the right window in my split window show that student sheet.

Is this possible to achieve?

She cannot find anything on internet about this.

I’ll hope there is a guru somewhere on this forum that can find a solution for her.

Thanks Martin!