How to prevent users from accessing Visual Basic Editor (VBE) for Microsoft Office applications?

If you want to prevent users from accessing Visual Basic Editor (VBE) on any PC / Workstation after you’ve installed Microsoft Office package (as there are certainly other ways to do it while installation), here’s the easiest way of doing this:

It is already mentioned over the link I shared above and I’m sharing it here just for my future references.
  1. Exit your version of all Office programs.
  2. Click Start, click Run, type regedit, and then click OK.
  3. Locate and then click to select one of the following registry keys, depending on the version of the product that you are using:
    • For Office 2013, locate and then click to select HKEY_LOCAL_MACHINESoftwareMicrosoftOffice15.0Common.
    • For Office 2010, locate and then click to select HKEY_LOCAL_MACHINESoftwareMicrosoftOffice14.0Common.
    • For the 2007 Office system, locate and then click to select HKEY_LOCAL_MACHINESoftwareMicrosoftOffice12.0Common.
    • For Office 2003, locate and then click to select HKEY_LOCAL_MACHINESoftwareMicrosoftOffice11.0Common.
    • For Office XP, locate and then click to select HKEY_LOCAL_MACHINESoftwareMicrosoftOffice10.0Common.
  4. After you select the key that is specified in step 3, point to New on the Edit menu, and then click DWORD Value.
  5. Type VBAOff, and then press ENTER.
  6. Right-click VBAOff, and then click Modify.
  7. In the Value data box, type 1, and then click OK.
  8. On the File menu, click Exit to quit Registry Editor.


References: Microsoft Support

Leave a Comment