+ Reply to Thread
Results 1 to 4 of 4

Using Excel built-in dialogs:-msoFileDialogFilePicker, are necessary tools

  1. #1
    Registered User
    Join Date
    01-21-2011
    Location
    Norway
    MS-Off Ver
    Excel 2007
    Posts
    3

    Using Excel built-in dialogs:-msoFileDialogFilePicker, are necessary tools

    Hello
    Built-in dialogs, like msoFileDialogFilePicker, are necessary tools.
    Using a ordinary Excel worksheets, right-click on the arrows at the left-bottom reveals a dialog listing all sheets which can be selected by a single click. I am not able to find the VBA-dialog, what is its name?

    Thanks.

  2. #2
    Forum Expert Colin Legg's Avatar
    Join Date
    03-30-2008
    Location
    UK
    MS-Off Ver
    2003, 2007, 2010, 2013
    Posts
    1,252

    re: Using Excel built-in dialogs:-msoFileDialogFilePicker, are necessary tools

    Hi,

    Do you mean the Workbook tabs commandbar?
    Please Login or Register  to view this content.
    Hope that helps,

    Colin

    RAD Excel Blog

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,180

    re: Using Excel built-in dialogs:-msoFileDialogFilePicker, are necessary tools

    This will invoke the dialog if the popup menu contains enough entries for the More sheets option to appear. Otherwise, as Colin showed, the popup will be displayed.

    Please Login or Register  to view this content.
    I can not find anything unique about the More sheet menu item to identify and execute it directly.
    Cheers
    Andy
    www.andypope.info

  4. #4
    Registered User
    Join Date
    01-21-2011
    Location
    Norway
    MS-Off Ver
    Excel 2007
    Posts
    3

    re: Using Excel built-in dialogs:-msoFileDialogFilePicker, are necessary tools

    Thanks! This works as expected. Hours saved.

+ Reply to Thread

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