How to Lock Excel VBA Code



To lock your VBA code in excel click on tools.
click on tools in your menu bar

Select macro.
Select macro from the drop down menu

Select visual basic editor.
Select visual basic editor

Select your vba project and right click.
Select VBA project and right click

Select VBA Project properties.
Select VBA project properties

Click on the protection tab.
Select the protection tab

Check the box to lock project for viewing.
Check the box for locking project for viewing

Enter your password and confirm this password. Click OK and your project is now locked.
Confirm your password and click OK

Related posts:

  1. How to Format Date in Excel via VBA
  2. How to Search in Excel via VBA Code
  3. Save in Excel. VBA Tutorial
  4. How to Write Excel Macros via VBA
Posted on February 27, 2013 by . This entry was posted in Office and tagged , . Bookmark the permalink.