Applies to: @RISK 5.x–7.x

Error:

The macro "...!GetPassword" cannot be found.

Cause:

This error likely indicates the macro is disabled due to security settings, the file location is not trusted, or the macro itself is missing or corrupted

Solution:

1. 1. Press Alt+F11 to open the VBA editor.

   2. Press Ctrl+R to open the Project Browser.

   3. Expand your workbook’s VBAProject → Modules.

      • If Modules doesn’t exist, right-click the project → Insert → Module.

   4. Open a module and paste:

      Function GetPassword() As String
          GetPassword = "your_password_here"
      End Function
      

   5. Replace the text with the actual password (keep quotes).

   6. Compile via Debug → Compile Project.

   7. Close VBA and save the file. If needed, save as .xlsm (macro-enabled).