A way around it could be to not allow the cell edit mode
Put this in the ThisWorkbook code module.
Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean)
Cancel = True
End Sub
Or to take it one step farther; cancel cell edit mode and then call a userform to allow the user edit the cell entry and have the userform timeout.
Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean)
Cancel = True
Load UserForm_Cell_Edit
End Sub
Bookmarks