开发者

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

开发者 https://www.devze.com 2023-02-06 10:34 出处:网络
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?

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

精彩评论

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