Results 1 to 8 of 8

Thread: Excel CalCulation Issue

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #3
    VBAX Regular
    Joined
    Jul 2010
    Posts
    15
    Location
    SamT,

    Where: File>>>Options>>>Formulas>>> Workbook Calculation>>> Automatic Radio Button is selected.

    How: In a ThisWorkBook Module (From The Tips and Tricks Sticky)

    Private Sub Workbook_Open()
        Application.OnTime Now, "ContinueOpen"
    End Sub
    "ContinueOpen" is:

    Sub RestoreSheetsCalculation()
      Dim sh As Worksheet
      For Each sh In Worksheets
        sh.EnableCalculation = True
      Next
      Application.EnableEvents = True
      Application.Calculation = xlCalculationAutomatic
    MsgBox "Auto-Calculation Enabled."
    End Sub
    I've checked all the other Modules and there isn't anything that would disable Automatic Calculation.
    This is what's weird here. It is an intermittent problem with a workbook that gets used, by me only, on a daily basis.

    Thanks for your help.

    C.R.
    Last edited by Aussiebear; 01-08-2014 at 03:19 PM. Reason: wrapped code with tags

Posting Permissions

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