Results 1 to 6 of 6

Tab navigation - is it possible to create drop down list

Threaded View

  1. #1
    Registered User
    Join Date
    04-05-2009
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2010
    Posts
    30

    Tab navigation - is it possible to create drop down list

    Hi,

    I sometimes work with spreadsheets (and Autocad drawings) having over 100 tabs. In Autocad, there is a nifty feature that allows you to open a drop down at the end of the tab area to navigate between tabs - see picture. Is there any way of doing this in excel? As these are client spreadsheets, I don't want to add macros or VBA to them.

    [ATTACH]574119

    Many thanks for any responses.

    Keith.
    Attached Images Attached Images
    Cheers ,
    Keith
    Excel 2010/16

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Create a drop-down list depend on 3 drop down list
    By jiaron_1230 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-20-2016, 10:02 PM
  2. [SOLVED] Create an Excel Drop Down list with Search Suggestions ( Serachable Dropdown list )
    By PMH2384 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-11-2016, 12:03 AM
  3. Navigation bar drop down
    By Ayoub99k in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-04-2015, 06:45 PM
  4. How to create a drop down list based on the choices of another drop down list?
    By Happy jain in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-27-2013, 01:54 AM
  5. Create a Drop down list based on another drop down list value
    By pdewet in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-26-2010, 06:54 PM
  6. Drop Down List ... Navigation to a Sheetname
    By atech in forum Excel General
    Replies: 7
    Last Post: 12-02-2007, 06:55 PM
  7. Can I create a drop-down list that will reference other drop-down
    By fdebelo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-07-2006, 05:40 AM

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