Thanks for the replies but what is outlined in the threads you attached did show promise did not do what I wanted (or I did not do them correctly). The code (added message) does tell the person running to click OK and then the user form is displyed.
Set form1 = UserForms.Login
ShowMessage ("Click 'OK' to Continue Execution")
Login = UserForms.Login.ShowModal()