以下是引用领风飞翔在2009-11-1 0:46:00的发言: 录制设置重算的过程就知道了 感谢老师查看,可就是录制不行,真对不行。 录制的结果开和关如下: Sub Macro3() ' ' Macro3 Macro ' 宏由 User 录制,时间: 2009-11-1 ' ' With Application .Calculation = xlManual .MaxChange = 0.001 End With ActiveWorkbook.PrecisionAsDisplayed = False End Sub Sub Macro4() ' ' Macro4 Macro ' 宏由 User 录制,时间: 2009-11-1 ' ' With Application .Calculation = xlAutomatic .MaxChange = 0.001 End With ActiveWorkbook.PrecisionAsDisplayed = False End Sub
|