Code A1 To Blink When Calculation Is Manual

    Hi all the great people,


    I have to alternate dozens of times each day between Automatic and Manual Calculation in my spreadsheet. Sometimes I erroneously pasted the formulated output as values without realizing that Calculation had not been done. As a result, I made many errors.


    Appreciate very much if someone can help me with a code such that whenever the Calculation mode is set to Manual on the worksheet, the content (or can be color-fill) in cell A1 will blink as a warning. Alternatively, you can also code all cells in Row 1 to blink whenever Calculation is in manual Mode.



    Code
    Sub ManualCalculation()
    Application.Calculation = xlCalculationManual
End Sub


    Thanks a bunch.

    Re: Code A1 To Blink When Calculation Is Manual


    BorneoHornbill,


    There is a way to start VBA code whenever certain events occur. Unfortunately, there is not an event called "On Change of Calculation" or such.


    However, if you want to, you could use the "Before Save" event to start code that would, for example, always turn calculation back to automatic.


    Hope that helps,
    Jim

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login