Hi all,

I have a single spreadsheet containing many tabs and the first tab being a contents tab listing every tab within the spreadsheet with a hyperlink next to each for quick reference. That is the easy bit.

What i am trying to do is create a universal floating text box which when clicked will jump straight back to the contents tab.

i.e. i can jump from the contents tab to each individual tab using the hyperlinks but i can't jump from the individual tabs to the contents tab. I have to dump export data into the individual tabs so creating hyperlinks within each one to the contents page doesn't work.

I've never used vba before but i am really keen to start and i think it may help me with what i'm trying to achieve. If i could get a noob's guide on how to get this punched out it will really set me on my way.

Cheers
Neill