excel - Opening a worksheet in another workbook -

i have 2 workbooks "studentid" , "student".

in book "studentid" there sheet list of id's in each row of column a. in "student" there sheets labelled each student id listed in workbook "studentid".

when student id clicked require specific worksheet id open in "student".

this written in vba.

i cant think of anyway enable this.

any appreciated.

as far not including code, understand need ideas start.

in studentid (.xlsm, or other macro-supporting extension), have rely on selectionchange event of specific sheet (under microsoft excel objects, file called sheet want track), is, have write like:

private sub worksheet_selectionchange(byval target range)     if (not isempty(selection.value))         on error resume next         'selection.value -> content of selected cell, is, id         'here have write code open corresponding worksheet in student workbook     end if end sub 

with small help, shouldn't find problem write required own.