Reference Library Conversion Question

[DeutchBose]

I have an Excel 97 Spreadsheet that has numerous macros
referencing the 'Microsoft Forms 2.0 Object Library'.
This reference seems to be 'standard'...when I open a
blank Excel 97 spreadsheet, this library is selected.

I run into problems, however, when I try to open this
spreadsheet in Excel XP. ExcelXP won't even let me open
the spreadsheet, giving me that standard Microsoft error:
"Microsoft Excel has an encountered a problem and needs
to close" with an option to Send an Error Report to
Microsoft, as well as recover and save the document.
When I recover and save the document, it loses the VBA
Project as well as all ActiveX Controls.

The problem seems to be the 'Microsoft Forms 2.0 Object
Library', which exists in ExcelXP, but is not selected.
Simply selecting it doesn't help, as by this point I've
lost the VBA Project.

Is there any way to make this library 'Standard' as in
Excel97?

Thanks for reading this long post...any help would be
greatly appreciated.

 

[Tom Ogilvy]

I am not saying that MSforms 2.0 is not the source of your problem, but not
having it selected in XP should have no effect. Each workbook contains its
own references, so when you say it isn't selected in XP, you are looking at
the references for the currently active project. If your workbook were
problem free, when you opened it in XP, MSforms 2.0 would be selected (if it
was properly installed in the registry).

If you can add a new userform with controls in a new workbook, then I would
assume it is installed correctly and registered.