Hide MS VBA screen in Excel 2010

Question

I work in an office where we have several amateur Excel experts who are constantly trying to “improve” (ie, reduce, change logic, rewrite to make “faster”) spreadsheets. Since I work in a very regulated world where macros must be approved by the company, the clients and the regulator modifying the macros are very no-no.

One of the problems is that people can get into the code even after we turn on password protection to set read-only sheets, and also set a password on the VBA Properties screen. Users seem to be able to bypass passwords and enter the main code without passwords set.

Is there anything else to stop them getting into the code? The idea that was discussed, but I can not find a link to it to prevent the VBA screen from opening. It can be done? Any other recommendations would be greatly appreciated.

Answer 1

Once you give your users physical access to a PC, you cannot guarantee that your security will not be defeated. The whole industry even says this:

If the bad guy has unlimited physical access to your computer, this is not your computer anymore

. , , VBA, VBA .

Office VBA, - , , , , .

, .

VSTO, Excel VBA .NET. / .

, , VBA , , , Excel VBA. , , , .

. , , , , .

, , , "" , , , , . , , / .