Excel 97 Macros in Later Version of Windows

[Partho]

I have an Excel file with macros developed in Excel97.
This file was used by a user in a later version of Windows
(I believe Windows 2003) and Office. I have now received
the file back from this user. I am trying to run the
macros in Excel 97 (in Windows NT 4.0) but with no
success. The macros which call up the user forms (dialog
boxes) are freezing.

Does anyone have any ideas about how to solve the problem?
Should I change any Excel settings or amend any code in
the macros?

Partho

 

[Simon Murphy]

Patho
This may be to do with modality
in xl97 forms were modal (ie everything stops when they
are shown) in 2000 and beyond they can be modal or non
modal.

In a version later than 97 try changing the show modal
property of the forms to false.

You could also try saving the workbook back in 97 close
and re-open, before running the code, this should strip
out the newer parts.

(and get everyone onto XP or 2003 - there are a few useful
enhancements over 97)

cheers
Simon