How can I restrict access to source code?

aryan_hr

Board Regular
Joined
Feb 19, 2002
Messages
222
Hi,
I wrote a big program in VBA which I need to restrict access to. what's the best way to password protect a VBA code, please?
I can put a password for my project in "VBAProject properties" but I am sure that there is an other secure way !!!!
any help?????
best wishes
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

phantom1975

MrExcel MVP
Joined
Jun 3, 2002
Messages
3,962
I'm afraid it isn't the fanciest means of protection, but you can also change the color of your font to match the background. That way if someone was able to get past your password, they would only see a bunch of blank pages. I'm not sure if there is a way to create a OPEN VISUAL BASIC event, but if you can figure it out, you can always have a hidden cell that must meet some sort of criteria before you can even open VBE. It's late and I'm just crapping out ideas......
 

Damon Ostrander

MrExcel MVP
Joined
Feb 17, 2002
Messages
4,239
Hi aryan_hr,

Yes, to my knowledge password protecting the VBAProject is the best and most secure way. But also be aware that unless the password is at least 9 characters in length and contains numeric characters it can be easily broken by any number of password-breaking codes, many of which can be downloaded for free on the internet.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,545
Messages
5,832,380
Members
430,128
Latest member
ojl987

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top