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