This one is For all the accomplished MVPs.
in [Programming]
|
From: BEETAL on 24 Mar 2010 08:06 Is there no way to fully protect a VBA project? I have come across many comments in the excel programming news group which say that it would take 30 seconds to un-protect a VBA project. What is the best way to make the opening up the VBA project as difficult as possible. I was expecting that 2007 Excel vesrion would have the best possible protection features.
From: JLatham on 24 Mar 2010 08:13 Check out this discussion: http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.excel.programming&mid=3097ca0d-da75-416e-8f1d-e9bfba487337&sloc=en-us Jan Karel Pieterse posted a method to protect Excel VBA code about as tightly as it can be. "BEETAL" wrote: > Is there no way to fully protect a VBA project? > > I have come across many comments in the excel programming news group which > say that it would take 30 seconds to un-protect a VBA project. > > What is the best way to make the opening up the VBA project as difficult as > possible. > > I was expecting that 2007 Excel vesrion would have the best possible > protection features. > >
From: Luke M on 24 Mar 2010 09:32 That's a pretty cool trick. -- Best Regards, Luke M "JLatham" <JLatham(a)discussions.microsoft.com> wrote in message news:99B1301F-A42E-4007-9E93-0F7427FBD7A5(a)microsoft.com... > Check out this discussion: > http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.excel.programming&mid=3097ca0d-da75-416e-8f1d-e9bfba487337&sloc=en-us > > Jan Karel Pieterse posted a method to protect Excel VBA code about as > tightly as it can be. > > "BEETAL" wrote: > >> Is there no way to fully protect a VBA project? >> >> I have come across many comments in the excel programming news group >> which >> say that it would take 30 seconds to un-protect a VBA project. >> >> What is the best way to make the opening up the VBA project as difficult >> as >> possible. >> >> I was expecting that 2007 Excel vesrion would have the best possible >> protection features. >> >>
From: BEETAL on 24 Mar 2010 15:00 Dear JLatham, Mike opened the protected workbook in less than 1 second. That was strange,no! "JLatham" wrote: > Check out this discussion: > http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.excel.programming&mid=3097ca0d-da75-416e-8f1d-e9bfba487337&sloc=en-us > > Jan Karel Pieterse posted a method to protect Excel VBA code about as > tightly as it can be. > > "BEETAL" wrote: > > > Is there no way to fully protect a VBA project? > > > > I have come across many comments in the excel programming news group which > > say that it would take 30 seconds to un-protect a VBA project. > > > > What is the best way to make the opening up the VBA project as difficult as > > possible. > > > > I was expecting that 2007 Excel vesrion would have the best possible > > protection features. > > > >
From: Peter T on 25 Mar 2010 05:30
Mike, > I would like to get hold of this file because frankly I cannot see any way > it could resist a passware attack using version 9.3 which I use. I used an older version so maybe that's the reason. If you want to leave your address here or contact me off-line (my address is lightly disguised in the reply-to field) I'll send you Jan Karel's file (with his consent). Regards, Peter T |