Hi

I'm also interested in this. What would be the code for both increasing and
decreasing the number of decimal places?

Thanks

"DougG" wrote:

I didn't before, but I do now. Thanks - that worked perfectly. Pretty weird
that there's no simple way to change the shortcut keys though.

The Shortcut Manager mentioned in Chirag's reply looked good until I saw
that it costs $30 after the trial period...

"Sheeloo" wrote:

If you know how to add macros to personal.xls then add the following
Sub findReplace()
Application.SendKeys ("^h")
End Sub

and assign the CTRL-f key to it.

"DougG" wrote:

I've been searching for a way to modify Excel 2007's keyboard shortcuts. So
far, no luck here or elsewhere.

Specific example: when I press CTRL+F, I want to go directly the REPLACE
tab of find + replace window (currently ctrl+H does this, while ctrl+F goes
to the FIND tab).

Thanks,
Doug