I built some VBA in Excel that morphs old accounting data from a "summary report" layout into a tabular layout in order to push the data into a new accounting system. The VBA won't run in the Parallels VM environment on my MacBook Air. Some details:
The code resides under a worksheet in a centralized Excel 2010 workbook (XLSM). It's configured to morph the data on 15 otherr XLSX files.
The code lives directly under one of the worksheets in the centralized workbook. It's launched from a command button on the worksheet. (See image below.)
The code runs just fine where I developed it, on my old Dell Studio (Windows 7, Office 2010 laptop).
For the life of me, I can't get it to run in the Parallels VM environment on my MacBook Pro 5. In Excel, I've enabled Macros, moved the XLSM and XLSX drive to the C: drive in Parallels, set the XLSM file as a trusted document. I've done everything I could think of to tell Excel, "Trust the damn file."
Yet, when I click the command button (image below) I get nothing, no error, nothing.