In the Visual Basic Editor click the Tools menu and then click VBAProject Properties. In Excel 2007, Excel 2010, Excel 2013, Excel 2016, and Excel 2016 for Mac, to password protect your macros in the VBA project, click the Developer Tab in the Excel ribbon, the click Visual Basic command button to open the Visual Basic Editor. How to protect Excel macro code and vba project For example, the VBA project for the Excel checkbook software (Georges Excel Checkbook Register / Georges Excel Checkbook for Mac) and Excel budget spreadsheet (Georges Budget for Excel) has been password protected to protect the copyrighted code and prevent and changes to it. Depending on the complexity of the VBA project and the required security measures, you may want to require a password to view the VBA project so that only those with the password can access and change the contents of the VBA project and VBA code. To protect the code in the VBA project, you can require a password to view the VBA project. Depending of what you are creating, code is stored in VBA modules, VBA user forms, VBA class modules and Microsoft Excel objects all of which make up the VBA project. The macros are created and stored directly in the Excel file (Excel Workbook) using the Visual Basic Editor. Applies to all Excel templates including: ' Georges Budget for Excel', ' Georges Excel Checkbook Register', ' Georges Excel Checkbook for Mac'Įxcel macros use VBA (Visual Basic for Applications) programming language to automate Excel tasks to save time and add additional functionality to Microsoft Excel.

Ms access password protect vba code