2 out of 2 rated this helpful - Rate this topic

Securing an Access, Excel, PowerPoint, or Word Add-in's VBA Project

Office XP

If you want to protect your code and prevent users from changing it, you can set a password for the add-in's Microsoft® Visual Basic® for Applications (VBA) project.

To set the project password

  1. Click VBAProject Properties on the Tools menu in the Visual Basic Editor.
  2. On the Protection tab, select the Lock project for viewing check box.
  3. Enter a password, and confirm it.

See Also

Building Application-Specific Add-ins | Word Add-ins | Excel Add-ins | PowerPoint Add-ins | Access Add-ins | Adding and Removing Command Bars for Word, Excel, and PowerPoint Add-ins | Controlling Word, Excel, and PowerPoint Add-ins from Code

Did you find this helpful?
(1500 characters remaining)