Results 1 to 7 of 7

Thread: calculate only when macro has been enable.

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Tutor
    Joined
    Sep 2009
    Posts
    231
    Location

    calculate only when macro has been enable.

    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 :
    [VBA]
    Sub CALCULATION()


    Worksheets("HANDFLAT").Activate

    ' With Application
    ' .CALCULATIONfull
    ' .Iteration = True
    ' .CalculateBeforeSave = True
    ' End With
    Application.CalculateFullRebuild

    Application.CALCULATION = xlCalculationManual

    End Sub[/VBA]

    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.


    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •