Project Unviewable

[daddyg_76266]

Hey folks! Long time user of the forums, first time poster. Even before I registered about a year ago, I have been using this forum for pretty much all of my Excel and VBA programming needs.

This subject has been discussed here many, many times as the search feature shows. However, I'm bringing up another thread about it because I don't believe there is a definitive answer to the subject.

My question is, how in the world does someone make a VBA project "unviewable" and at the same time, keep the workbook "unshared"???

The typical response is to share it. I'm not interested in sharing it because there are other workbooks in the world that aren't shared but still show this general error when attempting to expand the project.

I've tried numerous things mentioned in these forums and nothing works.

I hope that some of the geniuses here can help me find a solution.

[GC Excel]

If I understand correctly what you mean, you can protect it.

Open VBE Editor (ALT + F11)
Right click on the project > VBA Project Proprieties...
Proprieties tab
Click "Lock for display" (or something similar... my Excel is in French)
Add a Password if you want (make sure to remember it !!)

[daddyg_76266]

Thanks for reply GC Excel. I'm fully aware of how to add a password to it through the properties of the project. I'm talking about how to make the entire project unviewable. There are scripts (Excel based) that when you click on the + to expand the VBA project, an error message pops up with "Project is unviewable". However, the workbook is NOT shared.

I'd like to replicate this for some of the ones I'm doing.

[GC Excel]

I've found this link but haven't tested it :

http://www.mrexcel.com/forum/excel-q...excel-add.html

[daddyg_76266]

Yea...I've tried that as well and can't get it to work using MSO 07.

[shg]

....^....1

[shg]

GC Excel's suggestion has nothing to do with sharing, though sharing also makes a project unviewable.

Did you try it?

[daddyg_76266]

GC Excel's suggestion has nothing to do with sharing, though sharing also makes a project unviewable.

Did you try it?

Not to smack a gift horse in the mouth but did you read my original post?? I'm fully aware that sharing a workbook makes the project unviewable. I'm trying to figure out how to make a project unviewable without sharing it. It can be done.

And yes, I've already tried the link he provided and it does not work with MSO 07.

[shg]

Not to smack a thirsty horse standing next to the watering trough in post#2, right-click the project in the VBE, select Properties, click the Protection tab, and follow your nose from there. Do you see anything about sharing in that?

[daddyg_76266]

Not to smack a thirsty horse standing next to the watering trough in post#2, right-click the project in the VBE, select Properties, click the Protection tab, and follow your nose from there. Do you see anything about sharing in that?

Why would I see anything about sharing in post #2's directions? That's how to lock the VBA with a password which I'm fully aware of how to do. Locking with a password does not make a project unviewable. When you click the + project it'll prompt you to enter a password. Again, I am fully capable of locking a project down with a password. I've done it 100's of times. I've shared workbooks before, 100's of times, and I'm completely aware of that when you share a workbook, the VBA project becomes unviewable.

So again, how do I make a VBA project unviewable without having to share the workbook? I'm talking "unviewable" not prompted to enter a password.

I guess I wasn't clear enough in my OP.

[daddyg_76266]

Anyone have an idea?

[Kyle123]

What's the point? Why not just stick a password on it? - I've seen workbooks like you describe, I can't remember how it's done though, something to do with sharing, making an addin and unsharing again - seemed like a lot of effort for no reward to me, so I promptly forgot it

EDIT: Ah, just noticed that's in the link you posted

[daddyg_76266]

Well because I'd like to know how for one. I know that when it comes to my IP, Excel or Office for that matter really isn't secure at all. However, I'd still like to prevent as many folks from even being able to enter a password or use any other "crack" to get in it. It's happened numerous times already and I'd like to try and put a stop to it.

Those other tools that show a "project is unviewable" error can't be "cracked" by some of the pretty easy options and thus why I'm curious to know how it's done.

[Kyle123]

sure they are, they're just as simple as the password method :-)

[snb]

I did as SHG suggested; saved the file (essential) and attached it to this post.

[daddyg_76266]

I did as SHG suggested; saved the file (essential) and attached it to this post.

Love the filename.

This still allows for a user to enter a password. I'm trying to figure out how a user would get "Project is unviewable" when the project is expanded but the workbook isn't shared.

I've tried everything on these forums that attempts to create it but nothing has worked.

Edit - The msgbox "msg" was even better. And no, I think not.

[daddyg_76266]

And to help with any confusion....I'm trying to re-create the error attached that is generated when a user attempts to expand a VBA project.

The workbook is NOT shared.

[daddyg_76266]

Anyone know of a way?

[daddyg_76266]

Bumped for solutions.

[daddyg_76266]

Bumped again for some assistance.

[Richard Buttrey]

From something Tom Ogilvy wrote yonks ago. The URL's don't seem to be available anymore but presumably this is your answer.

Add-in: "Project is unviewable" message
If you are using Excel 97 and the project was protected in Excel 2000, I
believe you will get this message as well.
You can also get it if the workbook is marked as shared:
Here are some references:
Locked or digitally signed in Excel 2K
http://support.microsoft.com/support.../Q229/4/99.ASP
OFF97: Error Message: "Project Is Unviewable" Trying to View VBA Project
Locked or Digitally Signed in Office 2000 Program
Shared Project:
http://support.microsoft.com/support.../Q169/3/74.ASP
XL97: "Project Is Unviewable" Error Message When You Try to View Project
Created in Excel 5 or 95
http://support.microsoft.com/support.../Q160/1/31.asp
XL97: Cannot Modify Microsoft Excel 5.0 or 7.0 Add-in
Same as the first article but specific to Excel 2K
http://support.microsoft.com/support.../Q211/7/92.ASP
XL2000: "Project Is Unviewable" Error Message When You Try to View Project
Regards,
Tom Ogilvy
MVP Excel

[Richard Buttrey]

...and whilst this http://support.microsoft.com/default...b;en-us;823225 is specifically for Access it's possible that it's relevant to Excel.

[13lack13lade]

duno if this works, just did a quick google search.

Get a copy of VB6, create an ActiveX DLL project. Move most of your code
into the DLL project, and call the DLL from stub code in your template.

Regards
Jonathan West - Word MVP

or

http://www.doneex.com/index.php?opti...d=44&Itemid=86

[MK3010]

Hi, anyone know a way apart from 3rd party solution?

[Richard Buttrey]

@vutiehnp

Hi,

Unfortunately your post does not comply with Rule 11 of our Forum RULES.

Don't post questions regarding breaking or bypassing any security measure. Such posts will be deleted, and repeat offenders will be banned. This includes posting of links to sites that offer software, code or services to do this or posting of code to remove passwords

I have deleted your post

[vutienhp]

@vutienhp
Unfortunately your post does not comply with Rule 11 of our

I'm sorry.
I will learn from experience