PDA

View Full Version : hide and seek



ProteanBeing
12-21-2007, 02:09 PM
My dialog boxes will not hide. I have a main dialog box (switchboard) that the user opens other dialog boxes. When they are done with the others they should go away and display the switchboard. I can still however see the other dialog boxes behind switchboard. I've tried both hide and unload on my close button. What am I doing wrong? :bug:

rory
12-21-2007, 02:47 PM
Did you turn ScreenUpdating off? If so the Excel window won't redraw, so you see "ghosts" of the forms even though they have been hidden.

unmarkedhelicopter
12-21-2007, 03:52 PM
Have your switchboard larger than ALL the others and you won't notice :)

rory
12-21-2007, 04:15 PM
Or only turn off ScreenUpdating when writing to the sheet and then turn it back on. Or activate a blank sheet that is not the sheet being written to.