Can the Repeat key be changed?

[AstroGuy]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

By default, Command-Y is assigned to Repeat. I use Command-A for repeat in Word (history with earlier word processor continuing on). I'd like to assign that to Repeat in Excel, too, so that the keystrokes are consistent among my apps.

Repeat, however, doesn't seem to show up anywhere in the command list (in the Customize keys dialog)! I checked with All Commands for Repeat and Edit Repeat, and also under Edit and it's just not there! (Hope I've just missed it!) So, the wonderful keystroke reassigning feature seems to be missing one command!

 

[JE McGimpsey]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

By default, Command-Y is assigned to Repeat. I use Command-A for repeat in
Word (history with earlier word processor continuing on). I'd like to assign
that to Repeat in Excel, too, so that the keystrokes are consistent among my
apps.

Repeat, however, doesn't seem to show up anywhere in the command list (in the
Customize keys dialog)! I checked with All Commands for Repeat and Edit
Repeat, and also under Edit and it's just not there! (Hope I've just missed
it!) So, the wonderful keystroke reassigning feature seems to be missing one
command!

By design, the second control of the Edit Menu changes
captions/functions depending on what has been done previously (e.g.,
Redo, Repeat ______, where ______ is the last action taken).

XL's Customize Keyboard interface doesn't, AFAIK, allow you to access
that control directly. However, you could use this AppleScript:


tell application "Microsoft Excel"
try
tell command bar control 2 of command bar control ¬
"Edit" of command bar "Worksheet Menu Bar" to execute
end try
end tell

Paste it into the Script Editor app, and save it in your "Excel Script
Menu items" folder in your "~ocuments:Microsoft User Data" folder
(where ~ is your home directory), using a name like

RedoRepeat\mA.scpt

the

\mA

will cause XL to execute the applescript when CMD-a is pressed.

Note: This will work as long as you haven't moved the command (using
Customize Menus/Toolbars) or inserted another command above it in the
Edit Menu. Adjust accordingly.

 

[AstroGuy]

Nifty solution. I'll have to try it. Thanks!

It also occurs to me that I might duplicate the functionality by using iKey and assigning a keystroke to selecting that same menu command!