Work other Workbooks while Form Running

[garden_rael]

Is there a way to open and work other workbooks while a form is open?

If a user has my forms running and wants to open another workbook... it wouldn't open until the form is closed...

How can I avoid this?

 

[shg]

Try

MyForm.Show vbModeless

Certain controls (RefEdit) can only be on a Modal userform.

 

[garden_rael]

But the form remains there... that would only let me change the focus of the form, but switch windows right? or at least that's how I've seen it worked...

 

[shg]

What is the behavior you're looking for?

For a modal form, you can't set the focus elsewhere until you dismiss (Hide or Unload) the form.