Its not that I really want to disable the macro, but that I created it in
Excel 97. Now when I try to use the shortcut in 2003 nothing happens. It can
still be run via Tools, Macro etc.. And the keyboard shortcut is still setup
in options. Any ideas? I was wondering if there was a history of problems
like this between different versions of excel.

"Jim Rech" wrote:

If a shortcut is assigned to a macro via Tools, Macro, Macros, Options there
is no global way of disabling it. You would have to remove the shortcut
assignment or assign a null macro to it using OnKey:

Application.OnKey "^m", ""

When you removed the OnKey:

Application.OnKey "^m"

the former shortcut would work again.

--
Jim
"Burninator2000" wrote in message
...
| Can you enable/disable macro keyboard shortcuts in excel 2003?