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