How can I De-Activate a Dialog Box???

[NeilK]

Hi,

I was trying to find a way to keep a dialog box open however have it de-activate when I click out of it somewhere else on the workseet. Is this possible???

My dialog box has several Macro Command Buttons on it that sort the data on the worksheet in different ways. I want to keep the box open while still being able to look at the data on the sheet and being able to scroll around.

Any help would be greatly appreciated. Thanks!!!

Neil

 

[santeria]

Not totally clear on this... but I had thought that a dialog box could not be used as you wanted.
Unless you have customised something that might have additional properties [ ?]...

 

[Juan Pablo González]

Set the "ShowModal" property of that Userform to False.

 

[NeilK]

Thanks a lot!