PDA

View Full Version : Hide all userforms that are open



ProteanBeing
01-29-2008, 01:42 PM
Is there a way to do this? I have points in my program where I don't know which ones are shown.

Bob Phillips
01-29-2008, 02:07 PM
There is a problem here.

The (active) userforms are part of a collection, which you can iterate trough and get each collection member.

When you go through the collection, you will iterate in the order that they are created. If you show the forms modally, then trying to hide the next form may fail because you have to hide the topmost modal form first.

It would be far better to keep track of which forms are active rather than relying on a mop-up method.