Protecting VB Editor

[tiredofit]

It is possible to prevent users from seeing the VBA by adding a password (admittedly though it can be easily cracked).

However, is it possible to prevent users from opening the VB Editor at all?

The reason is my program has events but supposing for argument sake, the user opens the VB Editor and types in the Immediate Window (which they have access to, even if the code is password protected):

Application.EnableEvents = False

then my program will not behave as expected.

 

[frank_AL]

Lot's of solutions posted in many places. Here's one for you.

 

[tiredofit]

Thanks

 

[Jaafar Tribak]

Locking the VBProject from view will not prevent a stubborn user from disabling the application events from the Immediate Window or from code from another VBProject .. etc .

One thing I did in a project of mine was to have code to periodically check the Application Events status and automatically reset it to True if disabled.

Place this in the ThisWorkbook Module :

Private WithEvents cmbrs As CommandBars

Private Sub Workbook_Open()
    Set cmbrs = Application.CommandBars
End Sub


Private Sub cmbrs_OnUpdate()
    If Not Application.EnableEvents Then Application.EnableEvents = True
End Sub

The above code will ensure that the Application Events are enabled throughout the life of the workbook.

 

[tiredofit]

Thanks