<div>
Go into the VBA window, go to Tools, VBA Project Properties and on the Protection tab select Protect from viewing and add a password - don't forget the password !
</div>


Go into the VBA window, go to Tools, VBA Project Properties and on the Protection tab select Protect from viewing and add a password - don't forget the password !

<div>
<div class="content wysiwyg-content">
VBA<br />
How do I lock down my VBA code so that users running Macros in my spreadsheet are not able to modify or view the code. I have tried using the VBA Project Properties to lock it, but one can get around that fairly easily (either by clicking cancel or just going into the VBA interface directly)<br />
<br />

</div>
</div>


VBA
How do I lock down my VBA code so that users running Macros in my spreadsheet are not able to modify or view the code. I have tried using the VBA Project Properties to lock it, but one can get around that fairly easily (either by clicking cancel or just going into the VBA interface directly)



VBA Code Lock

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.

VB Script

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.