Results 1 to 4 of 4

Easy navigation through lots of worksheets

Threaded View

okili Easy navigation through lots... 07-18-2010, 08:28 AM
pike Re: Easy navigation through... 07-18-2010, 08:54 AM
okili Re: Easy navigation through... 07-18-2010, 09:15 AM
okili Re: Easy navigation through... 07-18-2010, 09:41 AM
  1. #1
    Registered User
    Join Date
    07-18-2010
    Location
    Tbilisi, Georgia
    MS-Off Ver
    Excel 2007
    Posts
    4

    Easy navigation through lots of worksheets

    Hi friends,

    When you got lots of sheets in excel workbook, it is hard to navigate through them. Probably most of you know that it is handy to right-click on navigation bar at the bottom left corner in excel window and the menu with the list of sheets will show up (see atttached image1).
    When you have lots of sheets, there is the last line "More sheets.." which shows up the "Activate" window (see atttached image2), where we can select any worksheet in activeworkbook to navigate. My problem is that I can not find any the command in VBA which will make this window ("Activate") to show up. I know that it would be easily built through VBA and Userforms, but my issue is to show up this window somehow (as it must be built-in) with or without VBA without using the mouse in this operation.

    I have also attached my try to do the similar thing, however I still want to make the built-in window to apprear.

    Thank you in advance for help
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by okili; 07-18-2010 at 09:42 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1