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.
 
         
                                         
                                         
                                         
                                        ![Interactive visualization of a graph in python [closed]](https://www.devze.com/res/2023/04-10/09/92d32fe8c0d22fb96bd6f6e8b7d1f457.gif) 
                                         
                                         
                                         
                                         加载中,请稍侯......
 加载中,请稍侯......
      
精彩评论