MrExcel Consulting
Your One Stop for Excel Tips & Solutions

Modal Userforms? Non Modal Userforms?

Posted by Ron on June 22, 2001 11:31 AM

I have an Excel workbook with many userforms I've created. Is there a way to allow the user to open and use other workbooks while a user form is open? Currently, when they go to another workbook the userform stays on top and doesn't allow the user to enter information on the other workbook.

Ideas or suggestion?? Thanks.

Posted by Damon Ostrander on June 22, 2001 12:20 PM


Modal userforms are not available in versions of Excel prior to 2000. In 2000 and beyond, set the ShowModal property of the UserForm to True.

Happy computing.


Posted by Ron on June 22, 2001 12:29 PM

Rephrasing the question........

Maybe I should rephrase the question. When the user opens this workbook, I have a userform display. The user must enter data in that form which follows a wizard-like format.

If the user has other workbooks open at the same time, they can't use them since this userform displays on top of the windows in any workbook within the Excel application. I would like the user to be able to go to another open workbook, use it and return to this one. I need the userform to be hidden or not display when the user moves to another workbook. Hope that's little clearer.