Hi,

I assigned a shortcut key to an Excel macro, but it is running totally
weird. I mean, I can run the macro from the VB editor screen using the
F5 function - it runs perfect, but when I try the short cut key, it
runs halfway into the program and then comes to a dead stop, and an
error screen pops up, saying "400". Why does this happen? Can anyone
please help?

Thanks,

Joe.