Creating navigation buttons on a worksheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ryan_dude - 20 Dec 2005 15:26 GMT

Hi
I'm trying to link togethor different pages on excel so i can navigate to
them from each page.

Also does anyone know how to create a drop down menu in excel?

Many Thanks in advance

Ryan

Reply to this Message

Dave Peterson - 20 Dec 2005 17:11 GMT

Maybe by using a hyperlink:
Insert|hyperlink
or
using the =hyperlink() worksheet function:

David McRitchie posted this and it might help you:

=HYPERLINK("#"&CELL("address",C5),C5)
=HYPERLINK("#"&CELL("address",sheetone!C5),sheetone!C5)
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)

> Hi
> I'm trying to link togethor different pages on excel so i can navigate to
[quoted text clipped - 5 lines]
>
> Ryan

Signature

Dave Peterson

Reply to this Message

CLR - 20 Dec 2005 17:15 GMT

You can create Navigation buttons by using Drawing Objects and assigning
recorded macros to them.
One way to get a drop down list is to use the Data > Validation
feature........
If you need assistance with either of these, post back and someone will help.

Vaya con Dios,
Chuck, CABGx3

> Hi
> I'm trying to link togethor different pages on excel so i can navigate to
[quoted text clipped - 5 lines]
>
> Ryan

Reply to this Message