View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Suren Suthar Suren Suthar is offline
external usenet poster
 
Posts: 2
Default 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?