Userform Log-in; Excel Hide and Unhide?

Hi Guys,

I am planning a little tool using userform in VB excel. What I really want to do is:
When I double-click the excel icon (means the Macro-enable Excel File; not the actual excel application) in my desktop I want UserForm named “Log-in” to initialize and excel workbook should be Visible = False.

Next when the user is Loged-in by appropriate ID and password the userform should disappear and excel workshhet named “Interface” should show-up - WBVisible = True

How can I achieve this? I know how to do the log-in userform but looking some help in hiding and reappearing excel workbook.

Basically, at the beginning I do not want excel to show up, only the userform “log-in” should be visible and once log-in excel should be visible and user-form should disappear. Thanks a lot.

i guess

Please Login or Register  to view this content.

then in the userform
with all the password etc code
if ok
application.visible = true

if it fails
Application.Quit

it needs to be in thisworkbook module

What do you want to happen when the user clicks "Disable Macros" at the start up?

One cannot disable the Enable Macros? dialog.

There are various workarounds (like very hiding sheets on Close) that make it harder for a user to bypass the password set-up, but the solution that I use is to forget the idea of "security" or "control" via VBA coding.
Design a workbook where the user will want to enable the macros and go through the password screen. Make it easier for them to do what they want to with your VBA. Fighting with users ("User wants to do X. I want Y, not X") doesn't end well. If the user wants X in order to do their job, give them X. Give them Y as well.

The coder is the user's servant, not their master.