| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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?? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| UserForm Shown while Program is Running other Code | Excel Programming | |||
| Code stops while Userform Shown | Excel Programming | |||
| Convert 29.08 hours (shown in decimal form) to time shown in "hh:m | Excel Worksheet Functions | |||
| VB code is not shown when recording drawing objects | Excel Programming | |||
| Named Ranges shown (or not shown) as blue means what? | Excel Worksheet Functions | |||
Hybrid Mode
