it would help if you show the macro code....



"Ted M H" wrote:

Running Excel 2007 under WinXPPro

I wrote four macros. The first three each do a specific funtion and are
named NameStateSum1, 2 and 3. The fourth one is named NameStateSum (no
suffix) and it simply runs the three numbered macros in order. The parent
macro is set up to run on CNTL+SHFT+N

If I run the parent macro from the developer tab, it runs fine. When I try
to run it with the shortcut keys, it executes only the first of three
submacros and stops.

Any idea what's causing this and how I can make it work with the shortcut
keys?