Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,836
Default I want to Protect VBA Code

I go to the VBA Editor, go to the Tools menu, choose VBA Project Properties,
then the Protection tab, then check the "Lock Project For Viewing" option and
supply a password with like 16 characters, or 20 characters, or some such
thing. How secure is this from cracking software that uses a brute force
method? How secure is it from anything?

Regards,
Ryan--

--
RyGuy
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,501
Default I want to Protect VBA Code

It's considerably better then workbook/worksheet protection but still not
good. I use passware to open files for clients

http://www.lostpassword.com/kit.htm

and the only time it let me down was a Portuguese language password which
included special characters and only then because I lost patience.


Mike

"ryguy7272" wrote:

I go to the VBA Editor, go to the Tools menu, choose VBA Project Properties,
then the Protection tab, then check the "Lock Project For Viewing" option and
supply a password with like 16 characters, or 20 characters, or some such
thing. How secure is this from cracking software that uses a brute force
method? How secure is it from anything?

Regards,
Ryan--

--
RyGuy

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default I want to Protect VBA Code

It's not secure at all.

It protects your code from people who can't seach google or people who don't
want to pay for a piece of software or from people who don't really care to see
your code.



ryguy7272 wrote:

I go to the VBA Editor, go to the Tools menu, choose VBA Project Properties,
then the Protection tab, then check the "Lock Project For Viewing" option and
supply a password with like 16 characters, or 20 characters, or some such
thing. How secure is this from cracking software that uses a brute force
method? How secure is it from anything?

Regards,
Ryan--

--
RyGuy


--

Dave Peterson
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default I want to Protect VBA Code

I don't agree.

There are techniques that remove the password from the project--not even bother
attempting to break the password.

Mike H wrote:

It's considerably better then workbook/worksheet protection but still not
good. I use passware to open files for clients

http://www.lostpassword.com/kit.htm

and the only time it let me down was a Portuguese language password which
included special characters and only then because I lost patience.

Mike

"ryguy7272" wrote:

I go to the VBA Editor, go to the Tools menu, choose VBA Project Properties,
then the Protection tab, then check the "Lock Project For Viewing" option and
supply a password with like 16 characters, or 20 characters, or some such
thing. How secure is this from cracking software that uses a brute force
method? How secure is it from anything?

Regards,
Ryan--

--
RyGuy


--

Dave Peterson
  #5   Report Post  
Posted to microsoft.public.excel.programming
JMB JMB is offline
external usenet poster
 
Posts: 2,062
Default I want to Protect VBA Code

It's not secure from anyone who can search the net and wants to break the
password. I got this to work on the first try:

http://shorterlink.co.uk/12699


"ryguy7272" wrote:

I go to the VBA Editor, go to the Tools menu, choose VBA Project Properties,
then the Protection tab, then check the "Lock Project For Viewing" option and
supply a password with like 16 characters, or 20 characters, or some such
thing. How secure is this from cracking software that uses a brute force
method? How secure is it from anything?

Regards,
Ryan--

--
RyGuy



  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,836
Default I want to Protect VBA Code

Thanks to all who responded!!

--
RyGuy


"JMB" wrote:

It's not secure from anyone who can search the net and wants to break the
password. I got this to work on the first try:

http://shorterlink.co.uk/12699


"ryguy7272" wrote:

I go to the VBA Editor, go to the Tools menu, choose VBA Project Properties,
then the Protection tab, then check the "Lock Project For Viewing" option and
supply a password with like 16 characters, or 20 characters, or some such
thing. How secure is this from cracking software that uses a brute force
method? How secure is it from anything?

Regards,
Ryan--

--
RyGuy

Reply
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
Can protect worksheet then workbook but not Protect and Share in code [email protected] Excel Programming 7 January 16th 17 07:01 AM
Protect via Code Q Sean Excel Programming 3 January 15th 07 02:06 PM
Protect Sheet with code, but then code will not Paste error. How do i get around this. Please read for explainations.... Corey Excel Programming 4 November 25th 06 04:57 AM
Generic protect/unprotect code through buttons and code? StargateFanFromWork[_3_] Excel Programming 4 December 31st 05 12:10 AM
How to Protect my code without anybody seeing Terry Excel Programming 5 November 30th 05 09:28 AM


All times are GMT +1. The time now is 06:38 AM.

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

About Us

"It's about Microsoft Excel"