View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Floating menu to navigate through worksheets

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