开发者

Excel: Is there an event to detect change in calculation mode (automatic/manual)

I would like code to run when the user or a macro changes the calculation mode from Automatic to Manual or Manual to Automatic. Is there an event that fires for this?

(The property is Application.Calculation in Excel interop.)

Usi开发者_JAVA百科ng Excel 2007


There is no event that fires for changing the calculation mode. About the closest you can get is to check at each calculation event.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜