How To Fix RSR_EXCEL_RUNTIME125 - Access to Visual Basic project denied

SAP Error Message - Details

• Message type: E = Error

• Message class: RSR_EXCEL_RUNTIME - Messages of the Excel Runtime

• Message number: 125

• Message text: Access to Visual Basic project denied

What causes this issue?

You tried to insert a design item that requires inserting VBA code into
the workbook. However, the VBA project for the workbook is locked for
viewing with a password.

System Response

The design item is not inserted into the workbook.

How to fix this error?

Unlock the VBA project for the workbook in the VBA editor and insert the
design item again.

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_RUNTIME125 - Access to Visual Basic project denied ?

  The SAP error message RSR_EXCEL_RUNTIME125: 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.
  Causes:
  
  Excel File Protection: The Excel file you are trying to export to 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 Compatibility: There may be compatibility issues between the version of Excel you are using and the SAP tool.
  Missing Permissions: The user may not have the necessary permissions to access the VBA project in Excel.
  
  Solutions:
  
  
  Remove Protection:
  
  If the Excel file is protected, try unprotecting it. You can do this by going to the "Review" tab in Excel and selecting "Unprotect Sheet" or "Unprotect Workbook."
  
  
  
  Adjust Macro Security Settings:
  
  Open Excel and go to File > Options > Trust Center > Trust Center Settings.
  Under Macro Settings, ensure that the option "Trust access to the VBA project object model" is checked. This allows SAP to access the VBA project.
  
  
  
  Check Excel Version:
  
  Ensure that you are using a compatible version of Excel with the SAP tool you are using. Sometimes, using an older or newer version of Excel can lead to compatibility issues.
  
  
  
  Reinstall or Repair SAP Add-Ins:
  
  If the issue persists, consider reinstalling or repairing the SAP add-ins for Excel. This can help resolve any underlying issues with the integration.
  
  
  
  Check User Permissions:
  
  Ensure that your user account has the necessary permissions to access and modify the VBA project in Excel.
  
  
  
  Use Alternative Export Methods:
  
  If the issue cannot be resolved, consider using alternative methods to export data from SAP to Excel, such as exporting to CSV or using other reporting tools.
  
  
  
  Related Information:
  
  SAP Notes: Check SAP Notes for any specific patches or updates related to this error. SAP frequently releases updates that may address known issues.
  Excel Documentation: Refer to Microsoft Excel documentation for more information on macro settings and VBA project access.
  SAP Community: Engage with the SAP Community forums for additional insights and solutions from other users who may have encountered the same issue.
  
  By following these steps, you should be able to resolve the RSR_EXCEL_RUNTIME125 error and successfully export data from SAP to Excel.