View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H. Mike H. is offline
external usenet poster
 
Posts: 471
Default 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.