Protecting Macros by using VBA Code

The only ways to protect individual macros are to use the Hidden property (Chapter 3) or to use workgroup security (Chapter 8 and the section the section "A Workgroup Security Refresher" earlier in this chapter). If you are not using workgroup security to protect macros, your only option is to convert them to VBA code, which you can do by following these steps:

1. Open the Database window and select Macros so that you can see all the macros.

2. Select the macro that you want to convert.

3. Right-click the macro and choose Save As.

4. Choose Module.

Please note that the MDE database format does not protect macros. Now I will show you how you can protect your VBA code.