Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Mark "track changes" in MS excel
Hi folks,
I am stuck with this topic so maybe you can help me. We sent out a template with data that have to be updated by our employees. We enabled "Track changes" (shared document) to verify what data was changed. So far so good. No I want to mark the cells that have changed, for example set the background color to red, and unshare the document (history will be lost). I have written a macro that marks a cells which have comments in it but how can I check if the cell was changed in the past? Thx in advance for your help. Christian P.S. the code to find a comment in a cell ##### snipet ##### Public Sub FindComments() Dim rngToSearch As Excel.Range Dim rngToFind As Excel.Range On Error GoTo ExitFindComments 'Set the range to check for comments Set rngToSearch = Selection For Each rngToFind In rngToSearch If Not rngToFind.Comment Is Nothing Then rngToFind.Interior.ColorIndex = 3 End If Next rngToFind ExitFindComments: End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting "question mark in block" at EOL in CSV files transformed fromXML | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
"Track Changes" - Prevent turn off track changes to meet SOX regs | Excel Discussion (Misc queries) | |||
how can I make an excel cell "mark" or "unmark" when clicked on? | Excel Discussion (Misc queries) | |||
Re-write "track changes" of Excel in VBA | Excel Programming |