Hot Keys Work Wonderfully . . . . But Stop Half-Way Through

[DougRobertson]

Hello,

I have enjoyed the benefits of Macros for years now, saving many an hour of tedious chores on Excel, but on a couple of my Hot Keys, the Macro will run part way through - and then just stop!

When I start the Macro from the Dropdown Box it works properly right to the end, and when I open the Macro in Code View and hit the "Play" button, same thing - it works like a charm, but for some reason, some Macros kick out part way through the program when initiating it with the assigned Hot Key.

Does anyone have any insight on this? I've re-assigned various Hot Keys - that I know work with other programs, but the same thing happens.

Thanks in advance,

~ Doug