Clara

I am writing an application that takes data from MSProject and writes it to excel. I want to set certain cells within the spreadsheet to change (color, highlight - it dosen't matter)
so I went into excel and recorede a macro in tracking changes and then I tried to apply that code to vb, It dosen't recognize the method ".HighlightChangesOptions When:=xlAllChanges " and I can't find anything similar in Vb. Her is the code from the excel macro.

Objxl.Range("A3").Select
Objxl.Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select
With ActiveWorkbook
.HighlightChangesOptions When:=xlAllChanges
.ListChangesOnNewSheet = False
.HighlightChangesOnScreen = True
End With
Does anyone know how I can make this work or offer a different solution to my problem.

as always I appreciate all of your help

thanks
clara

Granty

The method Workbook.HighlightChangesOptions accepts parameters(when, who, where).

So I am guessing you need
ActiveWorkBook.HighlightChangesOptions xlAllChanges
or
ActiveWorkBook.HighlightChangesOptions(xlAllChanges)

Sorry, cant test which atm...

italkid

I think the code will only work if the workbook is saved as a "shared" workbook. (not shure)