creating a "gateway"...

[bbadami]

what i would like to do is create a "gateway" where when i click on a certain cell it will open up a new page or open up to a different area of the spreadsheet that will contain more information

 

[Lewiy]

Welcome to the board!!

Have you tried using a hyperlink?
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
Right click the cell you want to use, select HyperLink
Choose “Place in this document”
Choose the sheet and cell you want to link it to

 

[bbadami]

I have not tried using a hyperlink, when I use the hyperlink am I able to have it go to a new excel spreadsheet? is that how that works?

 

[MickG]

Hi, Something like this would do:-

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

If Target.Address = "$A$1" Then
    Sheets("Sheet15").Select
        ActiveSheet.Range("A1:G10").Select
    End If

End Sub

Regards Mick

 

[Lewiy]

I have not tried using a hyperlink, when I use the hyperlink am I able to have it go to a new excel spreadsheet? is that how that works?

Try playing with the hyperlink options, it is quite flexible on where you can point it to.

 

[bbadami]

Thank You very much for your help. I have one more question relating to my previous one. I used the hyperlink thing and that worked very well, I am wondering if it's possible to somehow create a formula or hyperlink to where once i type in a certain number that excel will recognize it and immediately transfer me to the new document that i have created a hyperlink for