I am trying to use a hyperlink in a text box to link to another worksheet in
the same file. Does anyone know how and if this can be done?

Any help is much appreciated, thank you.