View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default Turn on Track Changes in Excel from C#

Michael,
You will have to share the workbook in order to track changes in Excel. You
should understand the consequences of that before you take that route.
You can record a macro to see the necessary code. However, as you have to
share the WB and you cannot record into a shared workbook, when you record
make sure you record to either another open WB or to a new WB.

NickHK

"Michael Howes" wrote in message
...

I generate a few word and excel documents from a c# application.
I was able to easily turn on Track Changes in the word document from
my code by setting Word.Document.TrackRevisions = true;

I can't seem to find how to turn on track changes in Excel from code.

any help appreciated
thanks
mike