SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 42657: "Code execution has been interrupted" when VBA code performs a double-click in SAS® Financial Management table

DetailsHotfixAboutRate It

If you include VBA code in a SAS Financial Management report or form and the code includes a 'double click' action - such as "Workbook_SheetBeforeDoubleClick" - the result might be an error message similar to

Code execution has been interrupted
This is caused by an ESCAPE message being sent to Excel via the application's API to ensure that the double click action does not cause a cell or cells to be put into edit mode.

This ESCAPE message return was needed in earlier releases of Excel, but it might cause the above error message in Excel 2010 and Excel 2007.

This is marked as fixed in release 5.3 of SAS Financial Management.

For additional information please contact SAS Technical Support.

For information on the SAS Financial Management Add-In API for Microsoft Excel, please refer to the SAS Solutions Services Customization Guide.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Financial ManagementMicrosoft® Windows® for x645.15.39.2 TS2M09.3 TS1M0
Microsoft Windows Server 2003 Datacenter Edition5.15.39.2 TS2M09.3 TS1M0
Microsoft Windows Server 2003 Enterprise Edition5.15.39.2 TS2M09.3 TS1M0
Microsoft Windows Server 2003 Standard Edition5.15.39.2 TS2M09.3 TS1M0
Microsoft Windows Server 2003 for x645.15.39.2 TS2M09.3 TS1M0
Microsoft Windows Server 2008 for x645.15.39.2 TS2M09.3 TS1M0
Microsoft Windows XP Professional5.15.39.2 TS2M09.3 TS1M0
Windows Vista5.15.39.2 TS2M09.3 TS1M0
Windows Vista for x645.15.39.2 TS2M09.3 TS1M0
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.