VBA Code not shown

[Subodh]

I have a Excel File containing VBA macros.
But when i want to view the VBA code by going to the does not ask for
password as it is expected for a Password Protected Project. Else, it
says, project is unviewable. Why is that? Is this something else
except a VBA Excel File? How can i see the code?
Thanks in Advance.

 

[Dave Peterson]

Is the workbook shared?

What version excel created the workbook?

What version of excel are you using to try to open the project?

 

[Subodh]

Is the workbook shared?

What version excel created the workbook?

What version of excel are you using to try to open the project?

The workbook is not shared.
I don't know the version of Excel which created the workbook.
How can i know the version of Excel? I tried to open the File with
version 2003 and 2007.
Is there anything I can do with the file to view the code??

 

[Dave Peterson]

Macro security encryption changed between versions. Newer versions should be
able to open the projects that were created in older versions.

The only time I've seen that "project is unviewable" message is when the
workbook is shared--or if I'm trying to open a project that was protected in a
newer version of excel--and I'm using an older version.

I don't have any other guesses.