Hi,
I'm almost there to solve the loss of undo/redo-stack and clipboard by VBA made changes.
I can already find out if the last keypress was undo or redo:
The only problem now is that I need to find out in Workbook_SheetChange if the last redo-count from 1 to 0 is a result from:
1) an actual mouse-click on the redo-button
2) or because of any other sheetchange that will also lose the last redo, setting it also from 1 to 0
So far I would capture the mouse click on the location where the buttons undo/redo are, but there position could change (Excel-version or User-defined)!
Any idea is welcome to investigate....
Thanks
I'm almost there to solve the loss of undo/redo-stack and clipboard by VBA made changes.
I can already find out if the last keypress was undo or redo:
Code:
If GetKeyState(vbKeyY) And -128 And GetKeyState(vbKeyControl) And -128 Then ' "Ctrl-Y" has been pressed
If GetKeyState(vbKeyZ) And -128 And GetKeyState(vbKeyControl) And -128 Then ' "Ctrl-Z" has been pressedThe only problem now is that I need to find out in Workbook_SheetChange if the last redo-count from 1 to 0 is a result from:
1) an actual mouse-click on the redo-button
2) or because of any other sheetchange that will also lose the last redo, setting it also from 1 to 0
So far I would capture the mouse click on the location where the buttons undo/redo are, but there position could change (Excel-version or User-defined)!
Any idea is welcome to investigate....
Thanks
