How To Fix RSR_EXCEL_RUNTIME114 - Access to Visual Basic project denied

RSR_EXCEL_RUNTIME114 - Overview

• Message type: E = Error

• Message class: RSR_EXCEL_RUNTIME - Messages of the Excel Runtime

• Message number: 114

• Message text: Access to Visual Basic project denied

What causes this issue?

When 3.x workbooks are upgraded, the VBA code in the workbooks is
checked to identify whether any 3.x BEx Analyzer APIs are used in the
code and whether they need to be upgraded to the new APIs. This check
requires access to the VBA project in Excel. Since access is denied,
this activity is not carried out.

System Response

The 3.x BEx Analyzer APIs cannot be upgraded. This is only relevant if
you have used APIs in the VBA code of the workbook and these APIs need
to be upgraded.

How to fix this error?

This is only relevant if you have used 3.x BEx Analyzer APIs in the 3.x
workbook that is being upgraded. The 3.x APIs are not upgraded and this
may lead to runtime errors when the workbook is executed.
To grant trusted access to Visual Basic project in Excel, proceed as
follows:
Open Microsoft Excel. Choose <ZK>Tools</> --> <ZK>Macro</> -->
<ZK>Security</>.
Choose the <ZK>Trusted Publishers</> tab page.
Select <ZK>Trust access to Visual Basic Project</>.
If you are not authorized to do this, contact your system administrator.

Procedure for System Administrators

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message RSR_EXCEL_RUNTIME114 - Access to Visual Basic project denied ?

  The SAP error message RSR_EXCEL_RUNTIME114: Access to Visual Basic project denied typically occurs when you are trying to export data from SAP to Excel, and the Excel file is either protected or has certain security settings that prevent access to the Visual Basic for Applications (VBA) project. This can happen in various scenarios, such as when using SAP Business Explorer (BEx) Analyzer or other SAP tools that interact with Excel.
  
  Cause:
  
  Excel File Protection: The Excel file you are trying to use may be protected, preventing access to the VBA project.
  Macro Security Settings: Excel's macro security settings may be set to a level that restricts access to the VBA project.
  Excel Version: Certain versions of Excel may have different security settings or restrictions that can lead to this error.
  Missing Permissions: The user may not have the necessary permissions to access the VBA project in the Excel file.
  
  
  Solution:
  To resolve the RSR_EXCEL_RUNTIME114 error, you can