Userform not hiding once task is carried out

I have a user form that's designed to come up when Excel opens, and the users name is not on the spreadsheet (i.e. it's the user's first time using the sheet).

Everything is working well, save the functionality to close the spreadsheet after OK_Click action in the user form. I've tried changing using userform.hide in both when conditions are met in the OK_Click action, and after the DO LOOP in the sub that calls the userform... neither have worked. Any suggestions?

Workbook open sub:

Please Login or Register  to view this content.

Userform:

Please Login or Register  to view this content.

Thanks in advance for any help you can lend. If you're familiar with selecting shape objects in a Range in Excel, I've posted another issue I've run into with this work book here.

Do you mean?

Please Login or Register  to view this content.

Yes, that would be ideal. When I used ConFullName.hide vbModal there I get a compile error that says Expected Function or Variable.

UPDATE: After some google work, I found that you literally meant to use Unload Me and it worked. Thanks for your help!