VBA Project Not Viewable

[Paul Mathews]

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.

 

[DS]

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

 

[Paul B]

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]

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 more Thanks again to
both of you.

Best regards,

Paul