I have a very strange problem in running a macro in Excel 2010 on my Windows 10 machine.
This macro called "CreateHurstChart" can be activated from a button located on the Ribbon under the Design tab (Chart Tools) when I have HURST.xltm loaded in. The macro is found in the PERSONAL.XLSB file (hidden) that is stored in the c:\users\Smith\AppData\Roaming\Microsoft\Excel\XLSTART directory path.
When I have HURST.xltm loaded and click on the button on the ribbon to run the macro, the VBA code does its thing and then pops open a Open File dialog window so that I can select a CSV file to load.
Once I double-click the file, the Open File window closes, the data from the CSV is loaded into a sheet, and then the VBA code continues by working on the data and creating a chart.
HOWEVER...
I had gone directly into the Properties of the CreateHurstChart macro and assigned a Short-cut key combination CTRL-SHIFT-S.
Thus, when I have HURST.xltm loaded, instead of clicking on the ribbon button as outlined above but instead using the Short-cut key combination, it goes through the motions as before up to where the Open File dialog pops up, I double-click the file to load, it loads it into a sheet, and then the VBA STOPS!
It doesn't process the CSV data it just loaded.
I cannot for the life of me figure out why it works fine using the ribbon button but stops after loading the CSV data using the Short-cut key combination.
Any ideas?
TIA
Bookmarks