Wrox Programmer Forums
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old February 25th, 2004, 10:38 AM
Authorized User
 
Join Date: Feb 2004
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default Secure VBA code!

Is there any way to really prevent users from viewing VBA code? I am told that passwords can be cracked easily enough.

I appreciate any input.

Thanks

 
Old February 25th, 2004, 12:31 PM
Authorized User
 
Join Date: Feb 2004
Posts: 18
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Passwords aren't that easy to crack, although I'm told determined hacker can get in. I've yet to have a problem within my firm (1000+ people), but I do not publish/sell outside. If you are really worried, you may need to write VB6 applications that are add-ins, rather than working in VBA.

Dave
 
Old February 26th, 2004, 07:17 AM
Authorized User
 
Join Date: Feb 2004
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks a million Dave. I hope to sell a program to banks and have thought about recoding the application in VB.net. Your reply has further prompted me in that direction.

 
Old March 10th, 2004, 06:07 PM
Authorized User
 
Join Date: Oct 2003
Posts: 41
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I made a similar enquiry to the beginning vb.net forum, asking about password security with EXE files...

http://p2p.wrox.com/topic.asp?TOPIC_ID=10548

...and discovered that if someone really wants your code they can basically get it if they have a copy of your software. I'm no expert but if you want security of code you probably need to be looking at encryption.


 
Old April 3rd, 2004, 06:43 PM
Authorized User
 
Join Date: Mar 2004
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Default

it's always been said,

if someone wants it bad enough they will get it.







Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA Code D0MiN0 Access VBA 2 March 31st, 2008 03:55 AM
Code works in Excel VBA but not Access VBA fossx Access VBA 2 May 21st, 2007 08:00 AM
vba code need in.ssuresh Excel VBA 2 November 29th, 2005 08:40 PM
vba code in.ssuresh Excel VBA 1 November 28th, 2005 05:10 AM
VBA Code tucker Excel VBA 1 March 22nd, 2004 10:11 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.