I need VBA code to make each combobox option on a userform open an excel workbook ...

Many Thanks ....

It sort of works.
When I click on the command button it opens up the new workbook and closes the userform on the original workbook and leaves that workbook open (which is what I want) but the new workbook is unresponsive (inactive) when it opens.

How do I make the new workbook active when it opens? ...

Edit: ** I've just noticed that when the new workbook opens as unresponsive (inactive), if I click back onto the original workbook with the userform, then click back onto the new workbook it becomes responsive (active) **