Customize Keyboard is not customizable

[BL]

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: Power PC

Hello, for some reason I can not create keyboard shortcuts, all is grayed out. The ADD, REMOVE, RESET ALL is grayed out.

How do I fix this...

Also can I reassign the short-cut CONTROL U to F2 the same as the windows version for edit the formula ? the CTR U is too far apart from each other thus require one finger for each hand.

Thank you for any help.

 

[CyberTaz]

In Excel 2004, yes you can use F2 but it needs to be accomplished
programmatically. Here's the recipe:

http://mcgimpsey.com/macoffice/excel/f2.html

As for the gray dialog, you may be seeing it exactly how it should be...
Those buttons don't wake up unless you either select something in the
Current Keys: box that *can* be removed or type a stroke into the new
keystroke box that can be [ADDED]. I don't know that I've *ever* seen the
[Reset All] button activated .

F that's not the problem I'd suggest that you first confirm that you're
fully (11.5.3) updated & second, try restarting your Mac. If that doesn't
correct the problem you might rename/remove your Excel .plist file [while no
Office apps are running] then launch Excel & see if it comes back to life.

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[JE McGimpsey]

Hello, for some reason I can not create keyboard shortcuts, all is grayed
out. The ADD, REMOVE, RESET ALL is grayed out.

How do I fix this...

The Reset All button won't be active until you've made a customization.

The Add button won't be active until a keyboard shortcut is entered in
the "Press a new shortcut key" input box.

The Remove button won't be active until an existing "Current keys"
shortcut is selected.

Also can I reassign the short-cut CONTROL U to F2 the same as the windows
version for edit the formula ? the CTR U is too far apart from each other
thus require one finger for each hand.

You can't reassign F2 the same way (but you could assign an easier
shortcut).

You can approximate it using VBA:

http://www.mcgimpsey.com/macoffice/excel/f2.html

 

[BL]

Thank you, I am now doing it right on the keyboard shortcut customization.

The F2 workaround worked as far as going into the EDIT MODE. But unfortunately it is not exactly what I was hoping for. In windows, I use the F2 to quickly verify a set of formulas by just looking at the color coding of cell references when you press the F2 or CTL+U in a mac. Is there another way so it will be exactly like clicking on the formula bar in a mac? (with the color coding of cell references).

Thank you again.

 

[CyberTaz]

Perhaps John can shed some additional light on that - although I'm familiar
with his macro I don't actually use it, so why the color coding doesn't
display I have no idea. The only other suggestions I can offer are to
dbl-click the cell or use CONTROL+' (left single quotation mark) which
toggles display of all formulas.

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[JE McGimpsey]

Thank you, I am now doing it right on the keyboard shortcut customization.

The F2 workaround worked as far as going into the EDIT MODE. But
unfortunately it is not exactly what I was hoping for. In windows, I use the
F2 to quickly verify a set of formulas by just looking at the color coding of
cell references when you press the F2 or CTL+U in a mac. Is there another way
so it will be exactly like clicking on the formula bar in a mac? (with the
color coding of cell references).

No - it's a slightly different command (which is why I wrote "something
similar" on my web page).

AFAICT, the highlighting/color coding is a U/I function piggybacked on
the command, rather than executed by the command itself. If you want
that feature, I think you're stuck with CTRL-u.

Blame MS for ever changing the shortcut keys when they ported XL from
Mac to Windows!