Resetting Keyboard Shortcuts

[Barb Reinhardt]

I'm reviewing a bunch of internal documents to determine if they contain any
macros and could be digitally signed. As I'm doing this, I'm finding that
many of these workbooks reset some of my keyboard shortcuts without setting
them back when done. (UGH!) Dontcha love it when that happens?

Anyway, how do I reset all of my shortcuts back to the default values. I'm
using Excel 2003.

Thanks,
Barb Reinhardt

If this post was helpful to you, please click YES below.

 

[Gary''s Student]

For shortcuts assigned to macros, use something like:

Application.MacroOptions Macro:="servient", ShortcutKey:="e"

For non-macro shortcuts, use OnKey

 

[Barb Reinhardt]

I really need to know how to set them all back to the "default" setting. How
do I find out what that is and do it?

Barb Reinhardt

 

[Gary''s Student]

Fortuately you do not need to know what the default is to restore it.

For example, suppose someone re-defined CNTRL-c and CNTRL-v and we did not
know that they should be Copy & Paste

Application.OnKey "^{c}"

still restores CNTRL-c to its default.

 

[Rosemary Jackson]

Thank you, thank you, thank you! I have been seriously stressing over this
same exact thing for 10 hours straight - I don't know how many times I
uninstalled & reinstalled Word. Wow, did I say thank you?