How To Fix RSR_EXCEL_RUNTIME128 - Visual Basic project is locked

SAP Error Message - Details

• Message type: E = Error

• Message class: RSR_EXCEL_RUNTIME - Messages of the Excel Runtime

• Message number: 128

• Message text: Visual Basic project is locked

What causes this issue?

The Visual Basic project for the workbook is locked for viewing with a
password.

System Response

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

How to fix this error?

To unlock the project, navigate from the workbook to the Visual Basic
editor to edit the project.
You can do this by pressing Alt+F11 or by choosing <ZK>Tools</> -->
<ZK>Macro</> --> <ZK>Visual Basic Editor</>.
You are then prompted to enter the password with which the project was
locked.

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message RSR_EXCEL_RUNTIME128 - Visual Basic project is locked ?

  The SAP error message "RSR_EXCEL_RUNTIME128: Visual Basic project is locked" typically occurs when you are trying to export data from SAP to Excel, and the Excel file you are attempting to use has a Visual Basic for Applications (VBA) project that is locked. This can happen for several reasons, including:
  Causes:
  
  Password Protection: The Excel file may have a VBA project that is password-protected, preventing access to the code.
  File Permissions: The file may have restricted permissions that prevent modifications or access to the VBA project.
  Corrupted File: The Excel file may be corrupted, leading to issues when trying to access the VBA project.
  Excel Settings: Certain settings in Excel may restrict access to VBA projects.
  
  Solutions:
  
  
  Unlock the VBA Project:
  
  If you have the password for the VBA project, you can unlock it by opening the Excel file, going to the VBA editor (press ALT + F11), and entering the password when prompted.
  If you do not have the password, you may need to contact the file's creator or administrator for assistance.
  
  
  
  Check File Permissions:
  
  Ensure that you have the necessary permissions to access and modify the Excel file. You may need to adjust the file's properties or consult with your IT department.
  
  
  
  Create a New Excel File:
  
  If the current file is corrupted, try creating a new Excel file and exporting the data from SAP to this new file instead.
  
  
  
  Change Excel Settings:
  
  Check your Excel settings to ensure that macros and VBA projects are enabled. Go to File > Options > Trust Center > Trust Center Settings > Macro Settings and adjust the settings as needed.
  
  
  
  Use a Different Export Method:
  
  If the issue persists, consider using a different method to export data from SAP, such as exporting to a CSV file or using a different format that does not involve VBA.
  
  
  
  Related Information:
  
  SAP Notes: Check SAP Notes for any specific patches or updates related to this error message. SAP frequently releases updates that may address known issues.
  Excel Version: Ensure that you are using a compatible version of Excel with your SAP system. Sometimes, compatibility issues can lead to unexpected errors.
  Consult Documentation: Refer to SAP documentation or user guides for additional troubleshooting steps related to exporting data to Excel.
  
  If the problem continues after trying these solutions, it may be beneficial to reach out to your organization's SAP support team or consult with SAP support for further assistance.