Short-Cut Key vs Ribbon Button Macro Activating

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

Hmmm!

This is strange, but I have seen macros triggered by Hot Keys fail before! (And not been able to work out why). But I an NO EXPERT!!!

Have you tried using a different Short Cut Key?

Have you tried running the macro from a button on your worksheet?

Have you tried moving the macro to the workbook (rather than PERSONAL.xlsb)?

Have you tried entering a "Stop" line in the code, then stepping through using F8?

Try these few things, and see how you go!

I hope this helps, please let me know!

Regards,

David


- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

Originally Posted by David A Coop

Hmmm!

This is strange, but I have seen macros triggered by Hot Keys fail before! (And not been able to work out why). But I an NO EXPERT!!!

Have you tried using a different Short Cut Key?

Have you tried running the macro from a button on your worksheet?

Have you tried moving the macro to the workbook (rather than PERSONAL.xlsb)?

Have you tried entering a "Stop" line in the code, then stepping through using F8?

Try these few things, and see how you go!

I hope this helps, please let me know!

Regards,

David


- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

I tried a few with same problem.

But then when I got to Cntl-T, one of the three letters not used in Excel (along with Q and L, which Q did not work), it works!

Weird! Seems the short-key combination itself was affecting the script.

Thanks for the suggestions.