Troubleshooting
Problem
User opens a macro-enabled spreadsheet (*.xlsm file) inside Microsoft Excel. User presses a button which enables some macro-related functionality. User then closes the spreadsheet (for example, closes Excel). A message box appears.
Symptom
- VBAProject Password
Password
Further Symptoms:
If the user clicks 'Cancel' then:
- If you are using Controller 10.2.1, then you get the same box. You click ‘Cancel’ 3 more times and (eventually) Excel exits/closes OK
- If you are using Controller 10.3 FP1 IF2, then you get this error message:
Microsoft Excel has stopped working
Problem signature:
Problem Event Name: APPCRASH
Application Name: EXCEL.EXE
Application Version: 15.0.4693.1000
Application Timestamp: 54b5cf28
Fault Module Name: Comctl32.dll
Fault Module Version: 5.82.9600.17810
Fault Module Timestamp: 553afcee
Exception Code: c0000005
Exception Offset: 0006e259
OS Version: 6.3.9600.2.0.0.272.7
Locale ID: 2057
[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.3;10.2.1","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSMRTZ","label":"IBM Cognos Controller on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
09 May 2025
UID
swg22006147