Select workbook (or workbook/worksheet) (Frm5)

Gives your user ability to select a workbook from list of open workbooks within same session.
Or call "SelectWorkbookWorksheet_ANmar" to give users option to select workbook/worksheet from list of open workbooks.
See examples

If user presses cancel, blank string is returned, in both functions

Call "SelectWorkbook_ANmar" function to show form asking users for a workbook, then return the selected workbook if selected, or null string if cancel.

Call "SelectWorkbookWorksheet_ANmar" function to show form asking users for a workbook/worksheet combination, then return the selected workbook name and worksheet name separated by {{$S$}}.

None

Msgbox SelectWorkbookWorksheet_ANmar()<br/><br/>Msgbox SelectWorkbook_ANmar()

Views 635 Downloads 292

'workbook', 'worksheet', 'workbooks', 'worksheets', 'sheet', 'sheets', 'book', 'books', 'file', 'files', 'tab', 'tabs', 'session', 'open', 'select', 'choose', 'cancel'

ANmarAmdeen
542
Attachments
Sessions VBA-Excel
Revisions

v1.0