charnaliaamit
New Member
- Joined
- Jun 15, 2012
- Messages
- 6
Hi
I request you to please provide me a code that provide the following solution as per the below query
I am using Excel 2007, I want the code for the following sheet profile
In my work sheet their is 20 Tabs and i have to work on all this simutaneously,
In my worksheet i Insert Hyperlink on each Tab except Ist 1st Tab back to index, when i click on this hyperlink i will back to Ist Tab,
First tab i insert a hyperlink for all the other tab.
Now i want all nineteen tab become automatically hide
and when i click on hyperlink on the Ist Tab for 3rd tab, 3rd tab become visible
and when i click on hyperlink Back to index on 3rd tab, i will come on the ist tab and 3rd tab beome hide
similarly when i click on hyperlink on the Ist Tab for 15th tab, 15th tab become visible
and when i click on hyperlink Back to index on 15th tab, i will come on the ist tab and 15th tab beome hide
I need this is happened in all the 19 tab
Thanks in advance
I request you to please provide me a code that provide the following solution as per the below query
I am using Excel 2007, I want the code for the following sheet profile
In my work sheet their is 20 Tabs and i have to work on all this simutaneously,
In my worksheet i Insert Hyperlink on each Tab except Ist 1st Tab back to index, when i click on this hyperlink i will back to Ist Tab,
First tab i insert a hyperlink for all the other tab.
Now i want all nineteen tab become automatically hide
and when i click on hyperlink on the Ist Tab for 3rd tab, 3rd tab become visible
and when i click on hyperlink Back to index on 3rd tab, i will come on the ist tab and 3rd tab beome hide
similarly when i click on hyperlink on the Ist Tab for 15th tab, 15th tab become visible
and when i click on hyperlink Back to index on 15th tab, i will come on the ist tab and 15th tab beome hide
I need this is happened in all the 19 tab
Thanks in advance