"Project is Unviewable" - Excel add-in

Status
Not open for further replies.

tipau

New Member
Joined
Jun 12, 2010
Messages
7
I have an excel add-in of which I'd like to view the code, however when I go to view it rather than prompting me for a password it comes up with:
Project locked, Project is Unviewable

An internet search threw up a couple of suggestions:

1. If can occur when using excel 97 or an earlier version.
I'm using 03 so this is not an issue.

2. It's a shared workbook.
This is an add-in not a workbook and doesn't have the same problem. I've converted a shared workbook (in which the project was unviewable) to an add-in and the project became viewable again.

Has anyone encountered this before? I'm interested in being able to protect my own projects this way if possible.

Thanks
 

lenze

Legend
Joined
Feb 18, 2002
Messages
13,690
Hi and welcome to the board!!!
A 3rd and likely reason is that the author of the add-in locked it from viewing to prevent you from seeing the code!! You protect a project via the VBAProject Properties dialog, Protection Tab!

lenze
 

tipau

New Member
Joined
Jun 12, 2010
Messages
7
Thanks for the reply lenze,

I know about the protection tab, but that can only password protect the project (so when someone attempts to open it they're prompted for a pass of your choosing). It wouldn't cause the Project is Unviewable message that I'm seeing.
 

tipau

New Member
Joined
Jun 12, 2010
Messages
7
Problem solved!

For anyone interested in truly protecting their VBA projects check out the following step by step guide posted on another forum by Jan Karel Pieterse:

1. Save the Excel workbook (.xls) file into an add-in (File > SaveAs.....)
2. After you have the saved add-in (.xla), close the Excel workbook (.xls)
3. Double click on the add-in to open it
4. Press Alt+F11 to access the add-in's vba project
5. Lock the vba-project with a password
6. Double-click on the "ThisWorkbook" code module
7. Press F4 to open the Properties window
8. Change the "IsAddin" status to FALSE
9. Return to Excel by Pressing Alt+Q (or close the vbe window)
10. Go to Tools > Share Workbook
11. When the dialogue appears, check the box for: (Allow changes by.....)
12. Press OK to close the Dialogue
13. When prompted to save, Press OK
14. Press Ok to accept that "macros cannot be accessed"
15. You should feel giddy at this point because you just realized what you have
been missing right under your nose
16. Verify that the [SHARED] appears in the application title bar
17. Now save the workbook again as an Add-in (File > SaveAs...) overwriting the
previous one
18. Close this Excel workbook without saving the changes (you don't need it)
19. Test out your newly saved add-in (open it, access the vbe, try to expand
the project window, you should get the new message "Project is Unviewable"
20. Your done

The project can't be opened using passware software or the "hex method" (at least the tests I've done indicate it can't).
:)

Tipau
 

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
That's neat (y) - straight onto my Favorites list!
 

Jeminar

New Member
Joined
Oct 26, 2004
Messages
18
Richard Schollar: that is not neat: it's sick and twisted complicated. I want to meet the disturbed individual who stumbled upon this.

I have a different problem: what is happenning when a project that should be fine complains instead that 'Project is Unviewable'. We can do precisely the same steps for lots of files, and on some of them, after applying a digital signature from Thawte, the signature disappears and the project becomes unviewable.

We can't see the pattern of behaviour. Any ideas?
 

tipau

New Member
Joined
Jun 12, 2010
Messages
7
It's really not complicated Jeminar, it takes about a minute to do. It's just been broken into lots of simple steps so it's easy to follow.
 

placebo2000

New Member
Joined
May 8, 2009
Messages
29
I'm sorry but this sharing method of locking a project is not secure and is very easy to bypass.
 

Jeminar

New Member
Joined
Oct 26, 2004
Messages
18
It's really not complicated Jeminar, it takes about a minute to do. It's just been broken into lots of simple steps so it's easy to follow.
It's easy instructions to follow; thanks. What I meant was that one day, some-one thought about this and came up with these things as a means to solve the problem. I can't see how they'd have evolved the idea step by step. Whatever sick and twisted individual saw the entire solution from the outset and was able to realize it would lock the project like that was insanely intelligent.
 
Status
Not open for further replies.

Forum statistics

Threads
1,082,283
Messages
5,364,268
Members
400,787
Latest member
bs04c

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top