Floating menu to navigate through worksheets

  • Thread starter Thread starter Banta
  • Start date Start date
B

Banta

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
 
Gord,

Thank you for your help. I appreciate.

Have a great day
Manuel
Click to expand...

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
 
Back
Top