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
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
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
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
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.