Function to Check if Cell is Highlighted for Change in Shared Work
What if you put a function in the ThisWorkbook area on selection change:
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target
As Range)
End Sub
Then you could monitor the changes yourself and create whatever log you want.
Note, you'll need to record the "starting" position of the cursor when you
open the workbook so you can then track a change. This is basically what I
use all the time. HTH.
|