Jim,

You could test the application version

Sub show()
If Val(Application.Version) = 9 Then
ShowNonModal
Else
ShowModal
End If
End Sub

Sub ShowNonModal()
UserForm1.show 0
End Sub

Sub ShowModal()
UserForm1.show
End Sub

You have to be careful of compilation errors in XL97, so you might need to
put the ShowNonModal proc in a separate module. I can't test as I don't have
97 handy.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"JimP" wrote in message
om...
To ALl,

I have a USER FORM that works fine as a MODAL form ... Since it was
developed on an Excel 97 platform. I understand and accept the
limitation ... IF the Workbook is opened on Excel 2000 platform,
however, I'd like to be able to Display the same form as Non-Modal ...

Question: Can it be determined in VBA code, prior to the USER Form
being loaded, that the current version of excel is capable of
displaying a Non-Modal form?

Thanks ....

Jim P