Re: Best way to secure VBA
It project protection. Under the VBA IDE you would click - Tools > Project Properties > Protection tab > check the box for "Lock project for viewing" > then enter in a password and enter in confirm password > click OK. Close your instance of your app, reopen, press Alt+F11 to open the VBA IDE, click on the project node to expand and view and you will get the same protection.
Then to view it enter in the password in the popup dialog box and it will open.
What app are you using?