Close a dialog Sheet

[Daniel Cremin]

Hi ppl i just need the code to close down a running old-style dialog sheet - .hide only makes it not active on screen, i need a way to close it down. Thanks

[Bruno]

Try this :

Unload YourUserForm
or
Unload YourDialogSheet
_________________

Bruno

[ This Message was edited by: Bruno on 2002-03-05 00:52 ]

[Daniel Cremin]

thanks for the tip, I actually know how to create and run modern dialog forms, the only prob is its a pre USERFORM (excel 97) type of Dialog Sheet that im making at the moment (you know the one where you can build it in Excel).
Ne one know the code to close it.

[Daniel Cremin]

can any one help me out with this?

[ This Message was edited by: Daniel Cremin on 2002-03-05 08:43 ]

[Daniel Cremin]

Please Please Please Help !!! Ive forgotten this line of code and no books contain it these days.

[Daniel Cremin]

please help if you can

[Daniel Cremin]

come on someone knows the answer!!!!!!!!!

[Bruno]

Hi Daniel
I don't know why the dialoogsheet is still there after hitting the OK button and .hide it...
Maybe you have to force a display update with : Do Events