Userform visible in another workbook

[Manish84]

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?

Please find attached the dummy file below
Test Userform.xlsm

Regards,
Manish

[simarui]

post this in your workbook code:

Please Login or Register  to view this content.

also, in each of your two worksheets you can store:

Please Login or Register  to view this content.

that way you can add more sheets w/out having to use the worksheet_activate code on every new sheet

[Manish84]

Thanks Simarui, for your reply. With your code i am successfully able to hide the userform when ever i am going to another workbook; but on returning back to the original workbook (in this case "Test userform" workbook) the userform is not visible on the activesheet. Can you please help me with this as well.

[simarui]

this probably isn't the cleanest way to do it... but:

Please Login or Register  to view this content.

seems to be working for me.

[Manish84]

Friends, please find the solved dummy file in another forum, and thanks Simarui, i think i was doing it in a wrong way. Thanks for your help.

Here is the link:-
http://chandoo.org/forum/threads/use...orkbook.22271/

[Debraj Roy]

Instead of playing with Hide / Unhide..

try Unload too..

Please Login or Register  to view this content.

[Manish84]

Thanks Deb, for your suggestion. I will do that.