LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 48
Default Discussion: VBA Project Code Protection

(Note: Let's "critically evaluate" the password protection feature for VBA Projects. We do not discuss "Techniques to break a password" here.
Also, let's restrict our scope to VBA projects.)


VBA Project protection:
===============
- In VBE, there is a feature to password protect your VBA project.
- In order to view the code and Userforms of a password-protected project, you need a password.

Also, Let's compare the VBA Project-Protection with the file-open password feature of an Office document, such as Word or Excel file.

Word, Excel file-open password:
====================
- With password "breakers", an average password of 7 or more characters takes ages to break by Brute-Force techniques.
- In order to open a file, you need to know the actual password. If a password is "hello", you need "hello" to unlock it.

VBA Project password:
===============
- No matter how long a password is, it takes less than 0.5 seconds to find out the password.
- Most VBA Project passwords have a 4-character "equivalent". It means, you set a 25 characters password, and someone can open it with a 4-character password.


Other Info:
=======
- The "History" of Word, Excel file-open password protection is longer than the VBA Project password protection.
- There should be no convincing arguement to say value of VBA code in a file is lower than the text or numbers in a file. Therefore, there is no convincing arguement to say that "VBA Projects deserve to be less securely protected".



Let's talk about this.
Welcome anybody's idea, welcome especially someone in Microsoft.

A Microsoft representative, for example, can tell us:
- how you did the functional specifications for that function;
- was the person who designed that function been fired or anyone should be held responsible for the w-r-o-n-g design?
- who decided to continue to adopt the wrong design? Who is responsible for this? (this is different from the point above.)
- tell us some names. (We deserve to know the names, as, for example, if you were killed you want to know who killed you.)
- Any escalation procedure for problems?
If "negative" for points 2, 3, 5 above, Microsoft, you have a lack of controls in your software development operations, and either your Group Internal Audit department or your auditors should be replaced.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Searching Multiple Timesheets for a project code and then.... Saitei Excel Worksheet Functions 1 May 26th 10 08:11 AM
Put Password Protection in Code Connie Excel Discussion (Misc queries) 3 October 25th 06 08:06 PM
Code for workbook protection Ant Excel Discussion (Misc queries) 2 July 1st 05 12:58 PM
Sheet Protection and VBA Code TheRobsterUK Excel Discussion (Misc queries) 1 May 27th 05 05:18 PM
inserted code into project but can't run it in run dialogbox cpudenusa Excel Programming 3 July 19th 03 06:24 PM


All times are GMT +1. The time now is 12:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"