Linking to a tab in another worksheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

brownang - 22 Jul 2005 11:28 GMT

I want to do a very simple task - click on a link in one worksheet and get it
to open a specific tab in another worksheet. Is this possible?

Reply to this Message

Ken Wright - 22 Jul 2005 15:02 GMT

Insert / Hyperlink / Place in this document

Signature

Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

>I want to do a very simple task - click on a link in one worksheet and get
>it
> to open a specific tab in another worksheet. Is this possible?

Reply to this Message

brownang - 24 Jul 2005 17:01 GMT

Ah, I forgot to say that it was a link to a tab in another workbook.

> Insert / Hyperlink / Place in this document
>
> >I want to do a very simple task - click on a link in one worksheet and get
> >it
> > to open a specific tab in another worksheet. Is this possible?

Reply to this Message

Ken Wright - 24 Jul 2005 18:53 GMT

OK, so hyperlink to the other document and then have an auto open code on
the other document that takes you to the required tab. It just means that
it will go there no matter who opens the file.

Regards
Ken.................

> Ah, I forgot to say that it was a link to a tab in another workbook.
>
[quoted text clipped - 4 lines]
>> >it
>> > to open a specific tab in another worksheet. Is this possible?

Reply to this Message

Bill Manville - 23 Jul 2005 00:15 GMT

Certainly can. You can even specify an address within the sheet.

Details of how to create it in Insert / Hyperlink may differ according
to your version of Excel (for example, in Excel 2000 browse to the file
and then click Bookmark).

What you should end up with is a hyperlink like
C:\MyDir\MyFile.XLS#'My Sheet Name'!A1

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

Reply to this Message