Userform visible problem

Dear Team,

I am having two userform (Userform1 & userform2) on my workbook.

In userform1 is having data entry type and Userform2 is for password entry for unhide all sheets..

My problem is when I press Cancel button from Userform2, the Userform1 also closing.

I want Userform1 should always visible until I press exit button

Can any one please help me to solve this issue. I attached my file here for your reference

Dear Roy,

I tried this code already. But I am getting error message that the userform1 is already in open

Dear Roy,

I checked your file. On you file you are hiding userform1 and activate Userform2. Then you are hiding userform2 and activating userform1.

But my case the userform1 should always visible. Userform2 only visible and hide

Dear Roy,

Thanks for your support.

I removed following line "Unload UserForm1" from my Userform2 code. Now Userform2 only hiding.

yes

I am having one more query. In mu userform1 Form11 (Last update) having 3 text box (22, 23, 24). In Textbox 22 using the following code for open calendar and select date.

My problem is the calendar is opening even if is select Textbox 23 & 24 also.

can you please check and correct me where I am doing mistake

This is the same workbook which is attached on my first post.

Once userform initialized at first time when I selecting any of the textbox inside Form11, the calendar is opening.

Once the userform is initialized, immediately if i select the textbox 23 or 24, the calendar is opening for me

yes you are correct. Sorry, it is my typing mistake. It is Frame 11.

But still the problem remains same

Quote from royUK

I think you mean Frame11. Theproblem is that the TextBoxes are in a Frame. Try this

Code

1. Private Sub TextBox22_Enter()
2. ' If Not bInit Then Exit Sub
3. g_bForm = ActiveControl.ActiveControl.Name = "TextBox22"
4. frmCalendar.Show_Cal
5. Me.TextBox22.Value = g_sDate
6. End Sub

Dear Roy,

Please help me to solve this calendar opening problem in the Frame11