VISHAL120
04-03-2013, 08:05 AM
Hi ,
I am trying work out with the attached files where the calculation has been set to manual.
And the file shall calculate only when the macro has been enable but not when disable as besides this there is a lot of check being done through VBA and if user click on the disable button and then the calculation is done it may have big different on the stock values.
here is the code am trying since long :
Sub CALCULATION()
Worksheets("HANDFLAT").Activate
' With Application
' .CALCULATIONfull
' .Iteration = True
' .CalculateBeforeSave = True
' End With
Application.CalculateFullRebuild
Application.CALCULATION = xlCalculationManual
End Sub
but the code seems not be working.
I am also attaching part of the file to have an idea.
many thanks for helping in advance.
:banghead::banghead:
I am trying work out with the attached files where the calculation has been set to manual.
And the file shall calculate only when the macro has been enable but not when disable as besides this there is a lot of check being done through VBA and if user click on the disable button and then the calculation is done it may have big different on the stock values.
here is the code am trying since long :
Sub CALCULATION()
Worksheets("HANDFLAT").Activate
' With Application
' .CALCULATIONfull
' .Iteration = True
' .CalculateBeforeSave = True
' End With
Application.CalculateFullRebuild
Application.CALCULATION = xlCalculationManual
End Sub
but the code seems not be working.
I am also attaching part of the file to have an idea.
many thanks for helping in advance.
:banghead::banghead: