Workbook Access Question

[torweb]

Is it possible to integrate a popup-type window within a worksheet that will display other available workbooks, then allow the user to open one of those workbooks.

With my current project, I've eliminated all of the Excel typical top file and menu options (Tools, Data, etc) but may want to provide a means of opening a second or third workbook. Currently, if I minimize the workbook I've opened and open another workbook, I have no way of switching between the two.

Thanks for any input!!

 

[TryingToLearn]

Is it possible to integrate a popup-type window within a worksheet that will display other available workbooks, then allow the user to open one of those workbooks.

Application.Dialogs(xlDialogOpen).Show

With my current project, I've eliminated all of the Excel typical top file and menu options (Tools, Data, etc) but may want to provide a means of opening a second or third workbook. Currently, if I minimize the workbook I've opened and open another workbook, I have no way of switching between the two.

Thanks for any input!!

Application.Dialogs(xlDialogActivate).Show