Hi! Need help to automatically show userform and running the workbook in background

Hi VBA master,

I would like to ask a trivial problem

So in my case, I would like to make a 'login form' to access my excel file, and I did it.
However, to make it more professional, when user open my excel file, I want the userform to be shown first, which is my login form and after user successfully provide their credential then the excel workbook will be served.

I've searched the solution and tried some, but it didn't fulfill my expectation, because the excel workbook will be opened in a glitch before the userform. Any recommendation of VBA code to fix the glitch?

Current code that I use is located in "This workbook" and here is the code:

[

Please Login or Register  to view this content.

]


Please enlighten me. Thanks

Code Tags Added
Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)