open another workbook - close - see again original form

**MJR** · 11-18-2012, 12:02 PM

Hi all,

A question please.

I have a master workbook. On a form is a commandbutton that opens a second file.
When the second workbook opens, my form disappears (automatically), the form from the second file appears.
I have placed this event in workbook.open.

When I close the second file, I see again the first workbook, but with no form.
I need the orginally form to be shown.

Can someone help please?

Please Login or Register  to view this content.

**HaHoBe** · 11-18-2012, 12:49 PM

Hi, MJR,

maybe you can use the Private Sub Workbook_Activate-event in ThisWorkbook for that like

Please Login or Register  to view this content.

As that event would alos fire when you just have switched to another workbook you may consider using a boolean variable to decide whether to show the form or loop through the forms to see if it´s open.

Ciao,
Holger

**MJR** · 11-19-2012, 06:20 AM

Hi Holger,

Thank you for your respons!
I placed your line in the workbook activate event.
No result.

After closing the second file there is no form appearing from the first.

Any other solution?
Mario

**HaHoBe** · 11-19-2012, 03:27 PM

Hi, Mario,

you placed the code in the workbook where the userform is located? The sample code works fine for me - please see a workbook attached (UserForm Button will create a new workbook, if you close that the form will be brought back up again).

Ciao,
Holger

**MJR** · 11-20-2012, 08:01 AM

Hi Holger,

Indeed your file works very fine.
Thank you for all your attention and work!

I stille have the problem in my case.
I have added two files (simplefied).

What am I doing wrong?

Thanks in advance.
Mario

**HaHoBe** · 11-20-2012, 01:56 PM

Hi, Mario,

I didn´t expect that the other workbook had a form as well and should be closed via that form. In that case the event which is triggered if a workbook is closed "as usual/normal" doesn´t get fired. A workaround for that is to call the macro to show the first form again before the workbook is closed:

Please Login or Register  to view this content.

Ciao,
Holger

**MJR** · 11-21-2012, 03:09 AM

Hi Holger,

Thank you for your patience and efforts!
And for your solution!
This works fine. I can surely work with this.

Thanks again.

Ciao,
Mario,