ExcelBanter - ShortCut

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - ShortCut (https://www.excelbanter.com/excel-programming/374042-shortcut.html)

Hi,

How to desactivate the ShortCut Ctrl + (dialog box to insert a line or column)

Thank for your collaboration.

As supplement to this question :

Ctrl + Shift + "+"
Ctrl + "-"
Ctrl + "+"

Each ShortCut opens the same dialog box (dialog box to insert a line or a column)
i cannot desactivate any of them ....

Any solution to this case ?

Thanks in advance for your help.

Salutations,

"DM" a écrit dans le message de news:
...
Hi,

How to desactivate the ShortCut Ctrl + (dialog box to insert a line or column)

Thank for your collaboration.

You can use code to stop that dialog from showing:

Option Explicit
Sub DeActivate()
Application.OnKey "^{+}", ""
End Sub
Sub ReActivate()
Application.OnKey "^{+}"
End Sub

Read VBAs help for .onkey and you'll see more info.

DM wrote:

As supplement to this question :

Ctrl + Shift + "+"
Ctrl + "-"
Ctrl + "+"

Each ShortCut opens the same dialog box (dialog box to insert a line or a column)
i cannot desactivate any of them ....

Any solution to this case ?

Thanks in advance for your help.

Salutations,

"DM" a écrit dans le message de news:
...
Hi,

How to desactivate the ShortCut Ctrl + (dialog box to insert a line or column)

Thank for your collaboration.

--

Dave Peterson

You can catch the shortcut key with code like:

Option Explicit
Sub turnitoff()
Application.OnKey "^{107}", "" '+ key
Application.OnKey "^{109}", "" '- key
End Sub
Sub turniton()
Application.OnKey "^{107}"
Application.OnKey "^{109}"
End Sub

A search of google found this:
http://groups.google.co.uk/group/mic...e26a616e83 00

or
http://snipurl.com/xmti

From: Kazuyuki Housaka - view profile
Date: Fri, Dec 27 2002 12:02 pm
Groups: microsoft.public.excel.programming

Hello,
This works on my PC.

Application.OnKey "{107}", "Add_Macro" '+ key
Application.OnKey "{109}", "Subtract_Macro" '- key

0 {96}
1 {97}
2 {98}
3 {99}
4 {100}
5 {101}
6 {102}
7 {103}
8 {104}
9 {105}
+ {107}
- {109}

Hope this helps.

DM wrote:

Thanks for your answer...I know this way of doing...
but this Sub do not deActivate these shortcuts on my computer
even thouth it's worked well for othe shortcuts !

the keys ("+" or "-") are the one from the numeric section of the keyboard...

Am i the only one ?

'-------------------
Sub DeActivate()
Application.OnKey "^{+}", ""
End Sub
'-------------------

Thanks for your participation.

"Dave Peterson" a écrit dans le message de news:
...
You can use code to stop that dialog from showing:

Option Explicit
Sub DeActivate()
Application.OnKey "^{+}", ""
End Sub
Sub ReActivate()
Application.OnKey "^{+}"
End Sub

Read VBAs help for .onkey and you'll see more info.

DM wrote:

As supplement to this question :

Ctrl + Shift + "+"
Ctrl + "-"
Ctrl + "+"

Each ShortCut opens the same dialog box (dialog box to insert a line or a column)
i cannot desactivate any of them ....

Any solution to this case ?

Thanks in advance for your help.

Salutations,

"DM" a écrit dans le message de news:
...
Hi,

How to desactivate the ShortCut Ctrl + (dialog box to insert a line or column)

Thank for your collaboration.

--

Dave Peterson

--

Dave Peterson

Thanks a lot, your solution works well.

Have a nice week-end.,

Salutations.

"Dave Peterson" a écrit dans le message de news:
...
You can catch the shortcut key with code like:

Option Explicit
Sub turnitoff()
Application.OnKey "^{107}", "" '+ key
Application.OnKey "^{109}", "" '- key
End Sub
Sub turniton()
Application.OnKey "^{107}"
Application.OnKey "^{109}"
End Sub

A search of google found this:
http://groups.google.co.uk/group/mic...e26a616e83 00

or
http://snipurl.com/xmti

From: Kazuyuki Housaka - view profile
Date: Fri, Dec 27 2002 12:02 pm
Groups: microsoft.public.excel.programming

Hello,
This works on my PC.

Application.OnKey "{107}", "Add_Macro" '+ key
Application.OnKey "{109}", "Subtract_Macro" '- key

0 {96}
1 {97}
2 {98}
3 {99}
4 {100}
5 {101}
6 {102}
7 {103}
8 {104}
9 {105}
+ {107}
- {109}

Hope this helps.

DM wrote:

Thanks for your answer...I know this way of doing...
but this Sub do not deActivate these shortcuts on my computer
even thouth it's worked well for othe shortcuts !

the keys ("+" or "-") are the one from the numeric section of the keyboard...

Am i the only one ?

'-------------------
Sub DeActivate()
Application.OnKey "^{+}", ""
End Sub
'-------------------

Thanks for your participation.

"Dave Peterson" a écrit dans le message de news:
...
You can use code to stop that dialog from showing:

Option Explicit
Sub DeActivate()
Application.OnKey "^{+}", ""
End Sub
Sub ReActivate()
Application.OnKey "^{+}"
End Sub

Read VBAs help for .onkey and you'll see more info.

DM wrote:

As supplement to this question :

Ctrl + Shift + "+"
Ctrl + "-"
Ctrl + "+"

Each ShortCut opens the same dialog box (dialog box to insert a line or a column)
i cannot desactivate any of them ....

Any solution to this case ?

Thanks in advance for your help.

Salutations,

"DM" a écrit dans le message de news:
...
Hi,

How to desactivate the ShortCut Ctrl + (dialog box to insert a line or column)

Thank for your collaboration.

--

Dave Peterson

--

Dave Peterson