Dazzybeeguy
Board Regular
- Joined
- Jan 6, 2022
- Messages
- 72
- Office Version
- 365
- 2010
- Platform
- Windows
I have the following code that paste the copied data as values when the user clicks in a cell.
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
On Error Resume Next
Target.PasteSpecial xlPasteValues
Application.CutCopyMode = True
End Sub
The problem is if they open the spreadsheet and click in a cell whatever is in their clipboard pastes in, there is no option to Undo / use Ctrl Z as its not there.
How can I give them the option to undo ???
Thanks
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
On Error Resume Next
Target.PasteSpecial xlPasteValues
Application.CutCopyMode = True
End Sub
The problem is if they open the spreadsheet and click in a cell whatever is in their clipboard pastes in, there is no option to Undo / use Ctrl Z as its not there.
How can I give them the option to undo ???
Thanks