Routine to create navigation buttons

Hello

I was hoping to create a routine that automatically creates a navigation bar (collection of rectangles that link to a specified tab in the workbook).

Within the routine I'm happy to hardcode

The tabs and the text for the each of the boxes and where it should link to:
Tab 1 should have Link 1 that links to Tab 2, Link 2 that links to Tab 3...
Tab 2 Shouuld have Link 2 that links to Tab 3, Link 3 that links to Tab 1...

The rectangle should be on row 3 of the worksheet and should be big enough to hold the text I define and the next rectangle should be placed next to the first with a small gap.

Is this at all possible?

Thanks

Allan

Hello allanr,

Just a suggestion. How about inserting a hyperlink instead? It would easier, faster, and give the user all the information needed.

Sincerely,
Leith Ross

Hello

Thank you for the suggestion it is much appreciated.

I have a lot of tabs and the same options/links need to be present on a collection of sheets so I really wanted to define the text, link location, etc and have the navigation bar automatically created to save time and in case there are any changes required in the future.

Thanks again

Allan