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.

Try closing excel completely and opening it again.

See if the 400 error goes away.

--
Regards,
Tom Ogilvy


"Joe" wrote:

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.