Prev: How to avoid '*' being used as wildcard in SUMIF?
Next: Rank Question
From: Lozzaw on 1 Feb 2010 14:30
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
> > >
 | 
Pages: 1
Prev: How to avoid '*' being used as wildcard in SUMIF?
Next: Rank Question