如何在Excel文档中找到跟踪更改？ [英] How to find Track Changes are completed in Excel Document?

问题描述

我如何才能发现使用Excel VBA或.Net在Excel文档中不再接受或拒绝更改？

任何帮助都会受到赞赏？

---

Selvam S

解决方案

嗨Selvam，

由于excel喜欢在保存之前计算，你可以经常使用：

 Application.CalculationState<> xlDone 

如果为真，那么可能会有变化......

How can i find there are no more changes to accept or reject in Excel document using Excel VBA or .Net?

Any help would be appreciate?

---

Selvam S

解决方案

Hi Selvam,

As excel likes to calculate before saving you can often use this:

Application.CalculationState <> xlDone

if true then there have likely been changes...

这篇关于如何在Excel文档中找到跟踪更改？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！