| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can you open a tab(Sheet5) by clicking on particular cell say.
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can you open a tab(Sheet5) by clicking on particular cell say.
So want when someone clicks on cell A2, that it will take the user to
Sheet5 Cell B62? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can you open a tab(Sheet5) by clicking on particular cell
"Chip" wrote: 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can you open a tab(Sheet5) by clicking on particular cell say.
Instead of writing code it would be easier to insert a hyperlink to the
required location |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Files won't open when clicking on them in Explorer | Excel Discussion (Misc queries) | |||
| how to open display the chart by clicking the cell in excel sheet | Charts and Charting in Excel | |||
| How open a file clicking directly over it? | Setting up and Configuration of Excel | |||
| can not open a xls file by double clicking | Excel Discussion (Misc queries) | |||
| Open Files by Clicking on a Cell | Excel Programming | |||
Hybrid Mode
