VBA to close UserForm on another book

I have this line of code:

Please Login or Register  to view this content.

The problem is, this workbook has a userform that displays when it is opened. I want my code to open the external workbook but not the userform, or close the userform right away once it opens.

Thanks