Hyperlink Macro / Hide Tabs
 

Hi

I have an Excel 2007 worksheet with 10 tabs. The first tab has a
contents section where each of the subsequent tabs is hyperlinked. By
clicking on the hyperlink I go to cell A1 of whichever tab I select.
In addition each tab has a hyperlink taking me to the contents tab. I
would like a macro where, when I click on a hyperlink, all tabs other
than the cover tab and the selected tab are hidden. In addition when I
click on the contents tab in a selected tab every tab is hidden bar
the contents tab.

Can anybody help?

Rup