Open A Workbook With Macros Disabled

[animas]

How to disable macros for a particular workbook using VBA code (even if user clicks enable macros during open)?

 

[jeffreybrown]

It seems to me your best option is to protect the code Tools > VBA Project Properties > Protection and then make all Sub's private.

This way if the user selects Alt + F8 there are no macros available to run and if they select Alt + F11 the VBAProject is password protected.

 

[animas]

I meant disable all vba code all together so that no vba will run even if macro is enabled.

I was trying something like

Public Sub DisableAllMacros()
    If Range("_DisableAllMacros") = "YES" Then
        Exit Sub
    End If
End Sub

Here user can select if vba should be in use, by changing value of named range _DisableAllMacros from a worksheet.

DisableAllMacros() sub can be called at starting of each vba sub or function.

Is there any more efficient way to do this task?

 

[jeffreybrown]

Not really sure on this one. Maybe somebody else will have a solultion.

One thing that could help is conditional compilation.

I don't quite understand it myself, but one thing it can be used for is switching back and forth between test and production.

Again, sorry I can't help more but surely somebody else has a great idea