Hide a UserForm on workbook deactivation

**aca** · 11-16-2009, 06:40 AM

I often have several workbooks open and shift from one to another.
One of these contains a floating UserForm; and the trouble is that when I leave this workbook and shift to another one, the UserForm belonging to the first remains open and visible in the new workbook; and I cannot hide this nuisance.
Within the same workbook, it’s easy to hide the Useform when shifting to another worksheet (through code for Private Sub Worksheet_Deactivate()).
Is there something similar for when the whole workbook is deactivated?

Thanks for any help.
ACA

**broro183** · 11-16-2009, 07:02 AM

hi Aca,

Yes, there is. Double click on the Thisworkbook module in the VBE, to open up the code window. At the top of the code window there should (?) be 2 dropdown boxes which probably state "(General)" & "(Declarations)". Change the left dropdown to "Workbook" & then look at the list of events by clicking on the righthand dropdown. I'm sure you'll find it by yourself (&... you can use this approach in other modules too, to identify possibilities) but you should end up with something like:

Please Login or Register  to view this content.

hth
Rob

**aca** · 11-16-2009, 07:53 AM

Thank you, Rob. Your instructions work perfectly.
Excuse me for being so inexpert as not to have thought of that myself, and having troubled you for that. Sorry.
ACA

**broro183** · 11-16-2009, 08:16 AM

Oi!
No need to apologise - all I meant to do in my last post was provide you with more knowledge that you can use in your future coding

Thanks for the feedback, I'm pleased I could help. Can you please mark the thread as solved?
Also, feel free to add to my reputation by clicking on the blue scales - it is appreciated

Rob