vba courses london - Protecting VBA code

The UK's most regular instructor-led training courses.
Training information: vba courses london · Excel london

Resolved · Low Priority · Version Standard

Protecting VBA code

Anton has attended:
Excel VBA course

by - delegate Anton [1 post] (2006 Nov 18 Sat, 22:24) Reply

What is the best way of protecting VBA code to make sure other users don't change it?

RE: Protecting VBA code

by - trainer Richard platinum contributer [818 posts] (2006 Nov 20 Mon, 13:11) Reply

To lock your VBA code, preventing viewing and modification, set Project Properties, using the following steps:

- Tools>Macro>Visual Basic Editor (Alt+F11).

- From within your project, select Tools>VBAProject Properties

- Click the Protection page tab and then check "Lock project from viewing"

- Enter your password and again to confirm it.

After doing this you must save, close & reopen the Workbook for the protection to take effect.

· How To Find A Good VB For Access Trainer
· What Is Microsoft Excel VBA and How Can It Help You Work Smarter?
· Visual Basic Returns To The Macintosh
· Should You Send Managers To VBA Training?
· Company Roles in Visual Basic Training

Vba tip:

Suspend DisplayAlerts in VBA

To stop Excel asking you things like "Do you want to delete this file...", use the following line of code at the beginning of the relevant VBA procedure:

Application.DisplayAlerts = False

At the end of the procedure make sure you use the following code to reactivate Display Alerts:

Application.DisplayAlerts = True

View all VBA hints and tips

Rate this page: