Locking off VBA

[Peterw_2506]

Hi everybody,

How do you lock the VBA screen (alt+11) in excel so other people can't screw the code up on you when a file has to be passed around in a team. I need to protect something which is going to be sent to a third party.

regards, Peter

 

[ISY]

Hallo

This code will disable commands Alt F11

Application.OnKey "%{F11}", "InsertProc"

They will not be enough to hide the code

 

[VoG]

In the VBE, Tools > VBA Project Properties, Protection tab, tick Lock project for viewing and supply a password. Save, close and re-open the workbook to see the effect.

 

[Rick Rothstein]

Click Tools/VBAProject Properties on the VBA's menu bar, click the Protection tab, select the "Lock project for viewing" checkbox and assign a Password where indicated (make sure you do not forget the password or you will not be able to get back into your own project).

 

[DonkeyOte]

http://www.ozgrid.com/VBA/protect-vba-code.htm

Remember that Excel is not a secure environment and most security can be circumvented by those determined enough to do so.