Disable code viewing

[jkeyes]

I searched and found Ivan's code for disabling all methods of viewing code here:

Sub DisableGettingIntoVBE()
   Application.VBE.MainWindow.Visible = False '// Close ALL windows 1st!
   CmdControl 1695, False                     '// Visual basics Editor
   CmdControl 186, False                      '// Macros...
   CmdControl 184, False                      '// Record New Macro...
   CmdControl 1561, False                     '// View Code
   CmdControl 1605, False                     '// Design Mode
   Application.OnDoubleClick = "Dummy"
   CommandBars("ToolBar List").Enabled = False
   Application.OnKey "%{F11}", "Dummy"
End Sub

The first line in the sub, however, is giving me a runtime error '1004', Programmatic access to VB project is not trusted.

Other than that line, everything works great... any ideas on a fix?

Thanks!

 

[Nimrod]

Why not just protect the VBE with a password instead of all this ?
1. Go into VBE
2. Select tools on menu
3. Select VBA Projects properties
4. In Properties window set password on Protection tab

 

[dk]

I searched and found Ivan's code for disabling all methods of viewing code here:

Sub DisableGettingIntoVBE()
   Application.VBE.MainWindow.Visible = False '// Close ALL windows 1st!
   CmdControl 1695, False                     '// Visual basics Editor
   CmdControl 186, False                      '// Macros...
   CmdControl 184, False                      '// Record New Macro...
   CmdControl 1561, False                     '// View Code
   CmdControl 1605, False                     '// Design Mode
   Application.OnDoubleClick = "Dummy"
   CommandBars("ToolBar List").Enabled = False
   Application.OnKey "%{F11}", "Dummy"
End Sub

The first line in the sub, however, is giving me a runtime error '1004', Programmatic access to VB project is not trusted.

Other than that line, everything works great... any ideas on a fix?

Thanks!

To fix your problem click Tools, Macros, Security and then click on the Trusted Sources tab. Tick the 'Trust access to Visual Basic project' checkbox and then click OK. However, Nimrod's solution is far more effective if you want to stop someone viewing your code

 

[njheathen]

Putting a password on code is only minimally useful without also preventing access to VBA. Users with access to VBA can run code in the immediate window, and most especially, can turn off event handling.