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

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

Look at Shortcut Manager for Excel at
http://officeone.mvps.org/xlsctmgr/xlsctmgr.html - it allows you to define
your own keyboart shortcuts to Excel menu items and macros. To define Ctrl+F
for Replace, do the following:
1. Download and install Shortcut Manager for Excel.
2. Start Excel and select "Add-Ins" tab, click "Customize Shortcuts" item.
3. Select "Edit" category.
4. Locate and select "Replace..." command.
5. Assign Ctrl+F shortcut to it.
6. Click OK button.

- Chirag

PowerShow - View multiple PowerPoint slide shows simultaneously
http://officeone.mvps.org/powershow/powershow.html

"DougG" wrote in message
...
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

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

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