Forum Discussion
I want to house multiple Workbooks in one Workbook. Is this possible?
You'd either have to link to the separate workbooks, or move all the sheets from all the workbooks into the workbook with the userform. Excel does not have the concept of a "workbook of workbooks".
You can store multiple worksheets in a single workbook. It is very well possible to let the user select a worksheet from a combo box or list box on a userform.
Storing multiple workbooks in a single workbook makes no sense.
HansVogelaar Each workbook has alot of tabs for project management. Thats why it would make sense. Like a Workbook Manager of sorts.
You'd either have to link to the separate workbooks, or move all the sheets from all the workbooks into the workbook with the userform. Excel does not have the concept of a "workbook of workbooks".
HansVogelaar Thanks you saved me a lot time on deciding my direction