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

the second option actuall is
Excel 97 - 2000 and xl5/95

so this saves two versions of the file in a single workbook so it can be
opened in xl5/95.

In any event, if you can see the forms and modules in the project explorer,
it usually means the project is unprotected. In xl2000, try exporting all
the code/modules/userforms, then delete them all, then save and close the
file, then open it back up and import everything, then save it. See if that
will open in xl97. If not, then repeat, but move everything to xl97 to do
the import.

--
Regards,
Tom Ogilvy

"ROBW" wrote in message
...
Hi Tom,

WHen I saved in Excel 2000 I get the option to save as a normal Excel
Workbook (*.xls) or as an Excel 97 - 2000 workbook (again *.xls). I tried
the second of these options after the first one didn't work.
Having gone back to XL2000 and saved the file with the project unprotected
in VBA, I can now see the list of individual forms/modules in project
explorer in XL97 but when I try to view the code/form I still get the
"Project Locked - Project is unviewable" error message. It wont even
allow
me to see the project properties to unlock it! I would normaly write the
code in the relevant verion but I'm tring to reuse a file I wrote at a
previous employer with a more up to date version of Office.

Many thanks,

Rob

"Tom Ogilvy" wrote:

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

Is the workbook "shared"?

Microsoft Knowledge Base concerning "shared" workbooks not allowing "viewing
of project"

http://support.microsoft.com/default...74&Product=xlw

Gord Dibben Excel MVP


-----Original Message-----


On Mon, 23 Aug 2004 07:23:02 -0700, "ROBW"
wrote:

Hi Tom,

WHen I saved in Excel 2000 I get the option to save as a normal Excel
Workbook (*.xls) or as an Excel 97 - 2000 workbook (again *.xls). I tried
the second of these options after the first one didn't work.
Having gone back to XL2000 and saved the file with the project unprotected
in VBA, I can now see the list of individual forms/modules in project
explorer in XL97 but when I try to view the code/form I still get the
"Project Locked - Project is unviewable" error message. It wont even allow
me to see the project properties to unlock it! I would normaly write the
code in the relevant verion but I'm tring to reuse a file I wrote at a
previous employer with a more up to date version of Office.

Many thanks,

Rob

"Tom Ogilvy" wrote:

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