ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   VBA Code not shown (https://www.excelbanter.com/excel-programming/436413-vba-code-not-shown.html)

Subodh

VBA Code not shown
 
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

VBA Code not shown
 
Is the workbook shared?

What version excel created the workbook?

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

Subodh wrote:

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

Subodh

VBA Code not shown
 
On Nov 20, 6:42*pm, Dave Peterson wrote:
Is the workbook shared?

What version excel created the workbook?

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

Subodh wrote:

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


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

VBA Code not shown
 
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.

Subodh wrote:

On Nov 20, 6:42 pm, Dave Peterson wrote:
Is the workbook shared?

What version excel created the workbook?

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

Subodh wrote:

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


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


All times are GMT +1. The time now is 10:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com