Choose Which Excel Sheet to OpenI have a spreadsheet with several sheets and want to create a script that will read the names of all the sheets and create a modal window letting the user choose which sheet to open then output the name of the chosen sheet as a string.
ScriptingWindowsRe: Choose Which Excel Sheet to OpenThe function Get Excel Worksheets will help you.