Hi,

I'm looking for way to disable the keyboard shortcuts
Shift Space ==> select row
Ctrl Space ==> select column
when entering formulas (starting with "=").
I find the 'select row' feature extremely annoying when typing
my formulas and inserting spaces for readability.

I have found how to disable the shortcuts when entering
simple values (without the "=") with something like this:
Sub Disable_shift_space()
Application.OnKey "+ ", ""
Application.OnKey "^ ", ""
End Sub
but it does *not* work when entering formulas.

Actually I don't see why, during formula entry, I would
need keyboard shortcuts to begin with.

Anyone any idea?

Thanks in advance,
Dirk Vdm

I don't think I've ever seen a useful macro that can be used when you're editing
a formula/value.

I think this is one of the annoyances you're going to have to learn to live
with.

Dirk Van de moortel wrote:
>
> Hi,
>
> I'm looking for way to disable the keyboard shortcuts
> Shift Space ==> select row
> Ctrl Space ==> select column
> when entering formulas (starting with "=").
> I find the 'select row' feature extremely annoying when typing
> my formulas and inserting spaces for readability.
>
> I have found how to disable the shortcuts when entering
> simple values (without the "=") with something like this:
> Sub Disable_shift_space()
> Application.OnKey "+ ", ""
> Application.OnKey "^ ", ""
> End Sub
> but it does *not* work when entering formulas.
>
> Actually I don't see why, during formula entry, I would
> need keyboard shortcuts to begin with.
>
> Anyone any idea?
>
> Thanks in advance,
> Dirk Vdm

--

Dave Peterson