How to protect VBA source code from view
Is it possible to protect the VBA source code from view?
Solution:
Solution 1:
In VBA right click on your project and select it's properties.
There you can password protect your code form being viewed
However this is not secure - rather refer to solution 2 as follows:
Solution 2:
There are methods to protect your hard work but come at a price.
Take a look at the link below for some explanations and a potential solution.
https://www.thespreadsheetguru.com/u...ord-protection
Obtained from the OzGrid Help Forum.
Solution provided by jl2509.
See also: Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions and Index to new resources and reference sheets
See also:
| How to use VBA Code in Excel to display a balloon |
| How to use VBA code to clear cells based on specific criteria |
| How to use VBA code - Find value from cell in different column and multiply by another cell |
| How to use VBA code to ccolour tabs based on tab/text number |
| How to use VBA code to insert a row at the top of a table |
Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.
Gallery
