Load & Unload UserForm when changing workbooks

Hello,

I have two workbooks. Test1.xls and Text2.xls
The Test1 workbook has 3 worksheets(sheet1, sheet2 and sheet3)

I have 2 userforms in workbook Test1.

On Workbook open event, I use this codes in “ThisWorkbook”:

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

On Userform1 I have a button that forwards to Sheet2 that opens the Userform2 using this code:

Please Login or Register  to view this content.

When I choose or open the Test2 file, I hide or Unload the UserForm2 ( Using the Private Sub Workbook_Deactivate() event which it is working)

Now, the problem is:
when I will go back to Test1 file, I want to show the UserForm2 again in vbModeless.
How can I do this?

Does anybody can help?
Thank you

Moderator Note:

Pls use code tags around your code next time as per forum rules.

Hi, OneSurya,

sounds to me as if you may use the Workbook_Activate-event in ThisWorkbook of Test1 file to do what you want.

Ciao,
Holger

Hi, OneSurya,

if you place this code in ThisWorkbook of Test1:

Please Login or Register  to view this content.

what is it that´s not working or what else are you expecting the code to do, quite frankly: I don´t get the use of

Please Login or Register  to view this content.

Ciao,
Holger

Hi, OneSurya,

Please Login or Register  to view this content.

Ciao,
Holger

Hello Holger,

Thanks for the reply.

Using this code below, both userforms appear the same time when I activate sheet2 or sheet3.

Please Login or Register  to view this content.

When I am in sheet2 and I choose or open the Test2 file, I hide or Unload the UserForm2 ( Using the Private Sub Workbook_Deactivate() event which it is working)

Now, the problem again is:
when I will go back to Test1 file sheet2, I want to show the UserForm2 again in vbModeless.

How can I do this?

Do you suggest any other solution?

Thank you,
Andreas

P.S. What are the code-tags? I used these <Code>

Hi, Andreas,

Fotis1991 asked you to apply code-tags in your opening post (which Fotis put in there for you) - I´m afraid you would need to add them to your last post.

If done you would need to make clear which sheet you want to be the active one (and which userform should be shown). From the code you posted both sheets will be activated and each of the UserForms be shown.

Again: please wrap your procedure with code-tags to allow us to reply to your question.

Holger

What are the code-tags? I used these
[Code]
code goes here
[\Code]

Is it ok?

Hi, Andreas,

normally you would use [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code]. Or you could edit the post and mark the code and hit #.

You would need to use a back-slash opposed to a slash to end the tags.

Please Login or Register  to view this content.

Ciao,
Holger

I edited the code and the post.
You can take a look at it.

Thanks
Andreas