ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   shortcut key running wild (https://www.excelbanter.com/excel-programming/356826-shortcut-key-running-wild.html)

Joe[_42_]

shortcut key running wild
 
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.


Tom Ogilvy

shortcut key running wild
 
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.




All times are GMT +1. The time now is 03:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com