SendKeys for Ctrl+Z and Ctrl+Y macros

[slack7639]

SendKeys for Ctrl+Z and Ctrl+Y macros . . . https://msdn.microsoft.com/en-us/vba/excel-vba/articles/application-sendkeys-method-excel

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Why doesn't this work consistently:

SendKeys ("^Z"), True

But this does:

Application.SendKeys ("^z")

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

While this works consistently:

SendKeys "{NUMLOCK}", True

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

2 EXAMPLES:

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Sub Ctrl_Z(control As IRibbonControl)

Application.SendKeys ("^z")
' SendKeys ("^Z"), True

End Sub

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Sub Ctrl_Y(control As IRibbonControl)

Application.SendKeys ("^y")
' SendKeys ("^Z"), True

End Sub

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

 

[slack7639]

bump