X
How.com.vn is a “wiki,” similar to Wikipedia, which means that many of our articles are co-written by multiple authors. To create this article, 17 people, some anonymous, worked to edit and improve it over time.
There are 10 references cited in this article, which can be found at the bottom of the page.
This article has been viewed 255,402 times.
Microsoft's Visual Basic for Applications (VBA) is the standard language for writing programs to automate functions and tasks in Microsoft Office. Understand how to protect VBA code so others can't sabotage or steal your macros.
For unprotection and removal of VBA passwords, see this article.
Steps
Method 1
Method 1 of 3:
Secure VBA Code with a Password
Open the Visual Basic Editor, usually found under "Macro" in the "Tools" menu. (In Access, you may need to be in the database window to reach the editor, depending on your computer set-up.)- Select "Project Properties" in the "Tool" menu within the Visual Basic Editor.
- Select "Project Properties" in the "Tool" menu within the Visual Basic Editor.
Go to the "Protection" tab.
Select the "Lock Project for Viewing" check box. If you don't check this box, you won't hide your code.
Create and confirm your desired password in the indicated boxes.
Save, close, and reopen your workbook for the protection to take effect. (In Microsoft Excel 2007 and later, you may need to save as an XLSM file for your code to work.)Advertisement
Method 2
Method 2 of 3:
Hide VBA Code in a Read-Only File with Access 2007
Method 3
Method 3 of 3:
Protect Your VBA Code by Making an Add-In
Create an empty Office file of the type that will use your code. (For example, if your code works with MS Excel, create an Excel file.)
Copy your VBA code into the Visual Basic Editor of that empty file.
Open the "Macros" window, usually stored under "Tools."
Test your code again, which debugs it.
Remove anything added to the empty file by your test.
Add a description to the macro that will run in your add-in. (You may need to select macro "Options" to be able to insert the description.)
Compile your code. (In the Visual Basic Editor, look under the "Debug" menu and select "Compile VBA Project.")
Save a copy of the file in a standard file type.
Go to "Tools" in the Visual Basic Editor, then select "Project Properties."
Select the "Protection" tab.
Activate the "Lock Project for Viewing" check box. (You may also need to set a password, depending on the specific file type you're working with and your settings for MS Office and your computer.)
Open the "Save As�" or "Save a Copy" dialog box.
Access the drop-down menu and change the file type to the appropriate type of add-in.- Save a Microsoft Word add-in as a DOT file, a document template. (If you want the add-in to run when you start Word, save it in the Word Startup folder.)
- Save a Microsoft Excel add-in as an XLA file.
- Save a Microsoft Access add-in as a MDE file, which will protect the VBA code. (Microsoft Access add-ins can also be saved as MDA files, but this doesn't hide the code.)
- Save a Microsoft PowerPoint add-in as a PPA file which will hide the VBA code and leave it unable for anyone other than you to access it or edit it.
Quit and reopen Microsoft Office. Your add-ins should now be usable.Advertisement
Community Q&A
Search
- QuestionWhat if I forgot my password to open the VBA project? Will it become unrecoverable?
Sylvia SaltaformajoCommunity AnswerUnfortunately yes, you won't be able to recover it using VBA editor you used to set the password. However, VBA passwords are easily removed by password recovery software such as Password-Find, Password Lastic, Rixler, etc, you can find it online.
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
SubmitAdvertisement
Tips
- If you can't find the VBA Editor or Add-In Manager, make sure it is installed on your computer. If not, you'll probably need to access your Office suite installation disks to install the necessary programs.Thanks
- Your specific settings and setup for Microsoft Office can affect where different functions are located in each program. If you can't find a function, try running a quick "Help" search for the function name.Thanks
Advertisement
References
- https://en.wikipedia.org/wiki/Visual_Basic_for_Applications
- http://www.ozgrid.com/VBA/protect-vba-code.htm
- http://office.microsoft.com/en-us/access-help/hide-vba-code-from-users-HA010239557.aspx?CTT=1
- https://www.stl-training.co.uk/article-371-vba-excel-2007.html
- http://msdn.microsoft.com/en-us/library/Aa140937
- http://msdn.microsoft.com/en-us/library/aa141032
- http://msdn.microsoft.com/en-us/library/aa140944
- http://msdn.microsoft.com/en-us/library/aa141283
- http://msdn.microsoft.com/en-us/library/aa140953
Is this article up to date?
⚠️ Disclaimer:
Content from Wiki How English language website. Text is available under the Creative Commons Attribution-Share Alike License; additional terms may apply.
Wiki How does not encourage the violation of any laws, and cannot be responsible for any violations of such laws, should you link to this domain, or use, reproduce, or republish the information contained herein.
- - A few of these subjects are frequently censored by educational, governmental, corporate, parental and other filtering schemes.
- - Some articles may contain names, images, artworks or descriptions of events that some cultures restrict access to
- - Please note: Wiki How does not give you opinion about the law, or advice about medical. If you need specific advice (for example, medical, legal, financial or risk management), please seek a professional who is licensed or knowledgeable in that area.
- - Readers should not judge the importance of topics based on their coverage on Wiki How, nor think a topic is important just because it is the subject of a Wiki article.
Advertisement
