Modal Forms
By default, forms are set to modal in Excel which means that when a form is show, the main application window (spreadsheet) is inaccessible as long as the form is shown. The main application window becomes accessible again when the form is closed.
There are cases however when both the form and the application window are needed simultaneously. In such cases, the form needs to be set as modeless through setting the “ShowModal” property of the UserForm to False.
just a quck note, if you need this is only an option from 2000 up, for 97 you need to use Steven Bullun’s class modual.
Comment by ross — February 9, 2005 @ 7:13 pm