Just FYI ...
Quote Originally Posted by firefytr
... Note this does NOT work in Excel 97, as it doesn't support this method; only in 2000 and greater. You can transversley use vbApplicationModal and vbSystemModal to NOT allow user access to either just the Application or the entire System (other Applications) until the Userform is dealt with.
... I stand corrected. This is a situation in which a userform can be shown Modeless in Excel 97 (dialog sheets in Excel 95) found here, by Rob Bovey using Windows API. Fwiw.