How can you open a tab(Sheet5) by clicking on particular cell say.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I made index on sheet 1. If my cell a2 has text INFO and my shhet 5 has the
details of INFO, what do I need to program so when I click on A2, it opens up
sheet 5 as soon as the clicking is done? Also as an alternate, I can store
iINFO details starting on cell b62. Can you go to b62 by clicking on a2?
 
So want when someone clicks on cell A2, that it will take the user to
Sheet5 Cell B62?
 
Chip said:
So want when someone clicks on cell A2, that it will take the user to
Sheet5 Cell B62?

Actually sheet 5 cell a1 or shhet 1, cell b62
Click to expand...
 
Instead of writing code it would be easier to insert a hyperlink to the
required location
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Application.Caller calls from ActiveWorkbook not the actual cell workbook 1
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3
On Cell click, start macro 5
Create if partial match then copy and paste data from one cell to another 1
Before Double Click Procedure 1
Matching Data between 2 Tabs on Same Workbook - then calculating 2
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1
Is Auto Expansion (i.e., wrap text) of a cell possible when thecell's contents are based on another 2

Back
Top