Userform visible in another workbook

[Manish Sharma]

Hi Friends,

I Have a workbook with 2 userform.
Userform1 is visible when sheet 1 gets activated
Userform2 is visible when Sheet 2 gets activated
Sheet 3 both the Userform are hidden.

Now when ever i open another workbook the userform are still visible even though the workbook which contains these are inactive. Is there any method by which we can hide the userform when the workbook in which it contained is inactive or minimized?

I have also attached the dummy file for your help.

Regards,
Manish

Below is the link of my post in another forum, this is to avoid any unnecessary work if the problem is solved in either of the forum:-
http://www.excelforum.com/excel-pro...986-userform-visible-in-another-workbook.html

 

[NARAYANK991]

Hi Manish ,

Is this OK ?

Narayan

 

[Manish Sharma]

Hi Manish ,

Is this OK ?

Narayan

Super, this is what i was trying to do. Thanks a lot NarayanK991, this is indeed a great help.

Thanks,
Manish