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

**torspake** · 02-04-2011, 08:06 AM

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.

**Colin Legg** · 02-04-2011, 08:23 AM

Hi,

Do you mean the Workbook tabs commandbar?

Please Login or Register  to view this content.

**Andy Pope** · 02-04-2011, 09:03 AM

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.

**torspake** · 02-13-2011, 03:42 AM

Thanks! This works as expected. Hours saved.

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

LinkBack

Thread Tools

Rate This Thread

Display

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

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

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

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

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions