Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Project Not Viewable
I sent out an automated Excel workbook to a number of users. One user is
encountering VBA errors. I tried to take a look at where the code was failing but when I attempt to access the VBA code, I get a message indicating that the "Project is not viewable" (Project Locked). I had password protected the VBA code prior to distribution but this prompt doesn't let me enter my password. It just tells me that the project is not viewable and that's it. Does anyone have any idea of what might cause something like this and if it's possible to get back access to the VBA code? Thanks in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Project Not Viewable
Hi Paul - sounds like your workbook is shared. VBA projects are not viewable
in shared workbooks - if you unshare it, you'll be able to view the VBA code, make your fix, and then reshare it. If it works fine when unshared, it sounds like your user is hitting something which isn't possible in shared workbooks (a number of formatting options, for example, are not permitted in shared workbooks.) Hope this helps DS |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Project Not Viewable
Paul, are you looking at in 97? if the project was created in 2000 or later
you will get this with 97, open it in a newer version to get access to it -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Paul Mathews" wrote in message ... I sent out an automated Excel workbook to a number of users. One user is encountering VBA errors. I tried to take a look at where the code was failing but when I attempt to access the VBA code, I get a message indicating that the "Project is not viewable" (Project Locked). I had password protected the VBA code prior to distribution but this prompt doesn't let me enter my password. It just tells me that the project is not viewable and that's it. Does anyone have any idea of what might cause something like this and if it's possible to get back access to the VBA code? Thanks in advance. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Project Not Viewable
DS and Paul B, thank you both so much for taking the time to reply. DS, you
got it exactly right. The user had indeed changed this to a shared workbook and, after unsharing it, everything resumed working properly. You're a lifesaver (a lot of folks are now very happy once mo) Thanks again to both of you. Best regards, Paul "DS" wrote: Hi Paul - sounds like your workbook is shared. VBA projects are not viewable in shared workbooks - if you unshare it, you'll be able to view the VBA code, make your fix, and then reshare it. If it works fine when unshared, it sounds like your user is hitting something which isn't possible in shared workbooks (a number of formatting options, for example, are not permitted in shared workbooks.) Hope this helps DS |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PROJECT NOT VIEWABLE? | Excel Discussion (Misc queries) | |||
text not viewable | Excel Discussion (Misc queries) | |||
Viewable columns | Excel Discussion (Misc queries) | |||
Some worksheets not viewable within a workbook on a particular PC | Excel Discussion (Misc queries) | |||
Picture is not viewable | Excel Discussion (Misc queries) |