ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Turn on Track Changes in Excel from C# (https://www.excelbanter.com/excel-programming/393188-turn-track-changes-excel-c.html)

Michael Howes

Turn on Track Changes in Excel from C#
 

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

NickHK

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





All times are GMT +1. The time now is 10:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com