Project is unviewable - for specialists

[Bogdan]

Hi there,

I downloaded an excel file having a few very interesting macros attached.
The problem was that the VBA project was password protected. So I used the
"Hex method" for replacing the password, but when I try to access the VBA
project, instead of dialog box for password input, I receive the message
"Project is unviewable". 2 additional comments:

- the file is not shared;
- I don't know in what version of excel the file was created (I use Office
2003), but I don't think is relevant because before "Hex method" when I tried
to access the VBA project a dialog box opened (so no "Project is unviewable"
message).

Thanking in advance for any help,

Bogdan

[Peter T]

If by the "Hex method" you mean the approach that can work in VBA to break
worksheet/workbook passwords, it does not work with VBA Project passwords.

You say you have downloaded a file, if project is locked it means the author
does not want to share the code that may have taken considerable time to
write. Is there a valid reason why you should not respect that.

Regards,
Peter T

"Bogdan" <Bog...@discussions.microsoft.com> wrote in message
news:A23316CF-6AAB-41F9...@microsoft.com...

[Mike H]

Hi,

Remind me what the 'Hex' method is with regard to viewing projects.

Mike

[Bogdan]

Thanks Peter. I know what you mean and somehow I agree with you. However, I
want to see the code for EDUCATIONAL purposes, i.e. I want to UNDERSTAND and
to LEARN how to develop such interesting and useful macros. So, if you want:
the purpose excuses the means of getting it :)

Regards,

Bogdan

PS The "Hex method" works with VBA project passwords ;)

[Bogdan]

Hi Mike,

Most probable you won't like the "Hex method" but...Basically, with a hex
editor you can easily replace the VBA Project password set up by another user
with your own password. It is really easy and efficient.

If you need further details, please let me know your email address as I do
not want to spread this method within community.

Regards,

Bogdan

[Don Guillett]

Let's see now. You justify breaking the authors code without permission
because YOU want to be educated and yet you don't want to show the method to
others. Why???

BTW. The methods are freely available to anyone willing to look and have
been frequently published here and elsewhere. I don't intend to help you.
Perhaps you should contact the author.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguil...@austin.rr.com

"Bogdan" <Bog...@discussions.microsoft.com> wrote in message

news:AD1107D4-EC18-4460...@microsoft.com...

[Mike H]

Hi,

I'm very familiar with this method and your correct I don't like it. The
author put the protection there for a reason.

Mike

[Bogdan]

OK guys, I get it, I won't find any help here...somehow I expected this, but
I tried anyway :)

Happy New Year!

Bogdan

[Jim Rech]

You get a "project is unviewable" if the add-in was created in Excel 5 or
Excel 95.

--
Jim

"Bogdan" <Bog...@discussions.microsoft.com> wrote in message

news:CBA59E7D-378E-4E49...@microsoft.com...

[Peter T]

Also - projects locked in XL9+ give the "project is unviewable" message in
XL8 (97)

Regards,
Peter T

"Jim Rech" <jrr...@hotmail.com> wrote in message
news:%23b8at9o...@TK2MSFTNGP03.phx.gbl...

[BK523]

I am having a similar problem (with "Project is unviewable") with a
spreadsheet that I wrote. The spreadsheet is a simple "log of events" that
has 4 or 5 simple macros written in it. The users of this log are using it
as a shared workbook and are having some problems with it. I wanted to look
at the code to make sure someone hasn't changed it somehow. Note that the
workbook is still shared - so I did a "Save As" and gave it a new name. Now,
in both the original workbook and my new copy, I get the "Project is
unviewable" message when I try to look at the VBA Code. Any Thoughts?

[Gord Dibben]

Saving as a new name does not remove sharing and shared workbooks have
project locked for viewing.

In either the original or the newly re-named workbook remove sharing to gain
access to your VBA project.

Gord Dibben MS Excel MVP

On Thu, 15 Jan 2009 12:34:06 -0800, BK523 <BK...@discussions.microsoft.com>
wrote:

[sudha]

Hi,

I have excel addin created using excel 95 version. I couldnt open the macro
since its throwing "Project is unviewable" warning. Please help to view the
macro code using Hex method or any other way.You can write to my email id
a_su...@yahoo.co.in. Thanks in advance.

--sudha

[Grant Fuller]

I have the same problem. I got a new position with a company and the
author of a project that is used company wide is no longer here. I have
to edit this project as the new programmer. I understand why the author
did this, but my intentions are pure.

How do I unlock this? When I double click on the projects, I'm not even
prompted for a password.

Thanks.

*** Sent via Developersdex http://www.developersdex.com ***

[tous...@gmail.com]

On Thursday, January 7, 2010 12:19:58 AM UTC+3, Grant Fuller wrote:
> I have the same problem. I got a new position with a company and the author of a project that is used company wide is no longer here. I have to edit this project as the new programmer. I understand why the author did this, but my intentions are pure.How do I unlock this? When I double click on the projects, I'm not even prompted for a password.Thanks.*** Sent via Developersdex http://www.developersdex.com ***

If the workbook is shared then you will get a message saying "Project is unviewable". Remove sharing and you will see the code or password prompt.

Touseef Ahmed