Hi,

I designed a spreadsheet with a user form & code in Excel 2000 and then
opened the files in Excel 97, however although the spreadsheet was visible,
the VBA project was unviewable. I went back into Excel 2000 and removed the
project protection and saved the file in Excel 97 format but the project is
still unviewable in Excel 97.

Any ideas?

Rob

Since xl2000 and xl97 use the same format, it is unclear how you saved in
Excel 97 format. Perhaps you should unprotect the project, then just save
the file and try to open it in Excel 97.

As a general rule, you should do your development in the earliest version of
Excel in which the project will be used.

--
Regards,
Tom Ogilvy

"robw" wrote in message
...
Hi,

I designed a spreadsheet with a user form & code in Excel 2000 and then
opened the files in Excel 97, however although the spreadsheet was
visible,
the VBA project was unviewable. I went back into Excel 2000 and removed
the
project protection and saved the file in Excel 97 format but the project
is
still unviewable in Excel 97.

Any ideas?

Rob