Could I just ask, why do you need to have your form open whilst you
are trying to switch to the 2nd workbook?

Turns out it isn't necessary to open another instance of Excel.
What I do need is a way of preventing a user from using Alt+F8 and Alt
+F11 and seeing or using macros except for one macro.