Show userform and hide excel

[Jeorge]

Hello there!

I have a userform and created a hide workbook command and a button to show it if I wanted to check the encoded information..
I used this commands on workbook

Private Sub Workbook_Open()

Application.Visible = False
LeaveApplication.Show

End Sub


then I created a button to show excel and inserted the command:

Private Sub ShowWB_Click()

Application.Visible = True
LeaveApplication.Hide

End Sub

Question:

1. Why does my excel file showed up first before userform appear (Which of course loss the privacy of the information entered in a glimpse though), and when userform was closed and open again in a matter of 5 seconds it will then open directly to worksheet without going to the userform.

2. Since I have a button to open my worksheet can I put a command to ask for a password before opening my worksheet to prevent other people to open and see the information encoded in my excel.

Thank you in advance for all the help you can provide.

 

[Jeorge]

Able to find an answer on my question on number 2, seeking for help on question number 1. Thank you

 

[CephasOz]

Why don't you add a worksheet, and just use it as a "splash" screen, giving general information (such as the name of the application, the version number, version date, and so on), and you can hide your data worksheet(s) entirely. The users never need to see anything but your userform and the splash sheet.

 

[Jeorge]

Hi CephasOz
Not that familiar with the splash using an extra worksheet, I will find it out. thank you for your idea.