For shortcuts assigned to macros, use something like:

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

For non-macro shortcuts, use OnKey


--
Gary''s Student - gsnu200815


"Barb Reinhardt" wrote:

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.