How about a sheet navigation toolbar from Dave Peterson?

http://www.contextures.on.ca/xlToolbar01.html

Or Bob Phillips' Browsesheets macro which I like best, but that's me<g

See this google search result. All one line for the URL

http://groups.google.com/group/micro...c19464f875bd25



Gord Dibben MS Excel MVP

On Wed, 9 Jan 2008 14:55:27 -0800 (PST), Banta
wrote:

Hello Community,

I am an VBA beginner with the following problem: I am creating a large
tool which will include several worksheets. For my users to be more
comfortable when working with the tool, I would like to have a
floating menu (always present, with static content) that will allow
them switch from one sheet to the other. The users won't create or
delete no sheets, so the menu content will be static. It's basically
like always showing them all available chapters of a book and allowing
them jump from one chapter to the other.

Any suggestions or hints on how to tacke on that.

I appreciate your help
Manuel