A hyperlink should be able to do it. When you do Insert=Hyperlink, then
select the file and location in the file you want to go to.

With reference to code, if you want help with code, you should post the code
you are having problems with - at least the relevant portions.

--
Regards,
Tom Ogilvy


"Chris" wrote:

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?