Hide or Lock VB codes in Excel

Hi ,
I have an excel sheet file with full of VB codes, need to give it to client, but don't want them to see all my codes.
At the same time, want them to be able to run.

Please advise
fparviniAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Patrick MatthewsCommented:
In the VBA Editor you can lock the VBA project with a password.  Keep in mind, though, that this password is inherently insecure, and can be cracked very, very easily using readily available, inexpensive hacking tools.
0
duncanb7Commented:
Take a look this for 3 method to secure your VBA
http://www.wikihow.com/Protect-VBA-Code

If method-2 is not safe enough , method-3, using Add-in that saved in other workbook will be
option

Duncan
0
Jerry PaladinoCommented:
Screen captures showing the steps to lock the VBA code for viewing and editing. Select the Protection tab in the VBAProperties Dialog check box, click the box to prevent viewing and enter a password required to open the project.  As Patrick noted above, this can be hacked very easily with tools if someone really wants your code.   If the requirement is to prevent your user community from accidentally changing the code, this works very well.  VBAProject SubmenuVBAProject Properties Dialog
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

James ElliottManaging DirectorCommented:
Share & protect the workbook is probaly the best of a bad bunce of options. That makes the VB project unviewable, and it's a bit harder to crack.

Rgds

Jell
0
Patrick MatthewsCommented:
Do note, though, that sharing the workbook is itself inherently dangerous; having multiple people in the file at once creates a huge risk of file corruption.  It is only a slight exaggeration to say that there are only two types of shared workbooks: those that are corrupt, and those that soon will be :)
0
James ElliottManaging DirectorCommented:
Very true
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
James ElliottManaging DirectorCommented:
Not sure that was deserved.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.