I can't find out how to hyperlink to a specific sheet in a file, so I am
trying to write some event code, so when a particular cell is selected it
opens the file and selects the correct sheet. Should I be able to do it
through hyperlink or is code the only way?
If code is the only way, can someone help I can't get it to work?