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

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

Gord !

Thanks heaps, great code ! !

One last question.. would you know, how I can keep the menu visible
all the time, but then again not activated? I mean, you would always
have the pop-up window, but then again still be able to keep working
on the sheet. You think that's possible?

Again, thanks for your help
Manuel

I assume the "great code" is Bob's Browsesheets macro.

You wouldn't want that sitting in the middle of the window, especially if you
had a great number of sheets.

To have a visible navigator, I would use the Navigation Toolbar from Debra's
site.

You can dock a Toolbar or have it floating.

NOTE: if you right-click on one of the navigation arrows at bottom left on
sheet tab bar you get a list of sheets.

Requires no VBA


Gord

On Thu, 10 Jan 2008 11:16:20 -0800 (PST), Banta
wrote:

Gord !

Thanks heaps, great code ! !

One last question.. would you know, how I can keep the menu visible
all the time, but then again not activated? I mean, you would always
have the pop-up window, but then again still be able to keep working
on the sheet. You think that's possible?

Again, thanks for your help
Manuel

Gord,

Thank you for your help. I appreciate.

Have a great day
Manuel

On Jan 11, 9:22 am, Banta wrote:
Gord,

Thank you for your help. I appreciate.

Have a great day
Manuel

to Manuel and Gord,

The floating toolbar as a concept for navigation is a great idea! I
was putting a command button on each sheet to move to others in the
workbook.

Duh, I shudda hadda V8!

Thanks much for the insight and the code references.

SteveM