Deactivaion of recalc on load

Discussion in 'Microsoft Excel Programming' started by Michael Hoffmann, Apr 1, 2008.

  1. Hi Excel experts,

    is there a way to deactivate the recalculation of all Excel sheet cells when a file is loaded, even if recalculation is set to
    "automatic" in the loaded sheet's options?

    Thanks!

    Michael
     
    Michael Hoffmann, Apr 1, 2008
    #1
    1. Advertisements

  2. Michael Hoffmann

    Michael Guest

    Place this in the ThisWorkbook object in the on Open event:

    Application.Calculation = xlCalculationManual
    and in the Before Close Event
    Application.Calculation = xlCalculationautomatic


    --
    If this posting was helpful, please click on the Yes button.
    Regards,

    Michael Arch.




    "Michael Hoffmann" wrote:

    > Hi Excel experts,
    >
    > is there a way to deactivate the recalculation of all Excel sheet cells when a file is loaded, even if recalculation is set to
    > "automatic" in the loaded sheet's options?
    >
    > Thanks!
    >
    > Michael
    >
    >
    >
    >
     
    Michael, Apr 1, 2008
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Bura Tino

    recalc question

    Bura Tino, Jul 10, 2003, in forum: Microsoft Excel Programming
    Replies:
    2
    Views:
    684
    Bura Tino
    Jul 10, 2003
  2. Guest

    Not recalc in custom function

    Guest, Mar 1, 2004, in forum: Microsoft Excel Programming
    Replies:
    11
    Views:
    377
    Charles Williams
    Mar 2, 2004
  3. Steve

    UDF recalc question

    Steve, Mar 11, 2004, in forum: Microsoft Excel Programming
    Replies:
    3
    Views:
    366
    Frank Kabel
    Mar 11, 2004
  4. Sandy V

    UDF recalc problem between sheets

    Sandy V, Apr 8, 2004, in forum: Microsoft Excel Programming
    Replies:
    7
    Views:
    352
    Sandy V
    Apr 9, 2004
  5. Bura Tino

    Recalc versus enter

    Bura Tino, Apr 29, 2004, in forum: Microsoft Excel Programming
    Replies:
    20
    Views:
    634
    Bill Renaud
    May 3, 2004
  6. Tom Pachulka

    Excel 2000 formula recalc problem

    Tom Pachulka, Jun 21, 2004, in forum: Microsoft Excel Programming
    Replies:
    2
    Views:
    366
    Tom Pachulka
    Jun 22, 2004
  7. GMet

    Auto ReCalc

    GMet, Oct 5, 2004, in forum: Microsoft Excel Programming
    Replies:
    4
    Views:
    316
  8. Guest

    Force recalc of formulas saved as text

    Guest, Dec 3, 2004, in forum: Microsoft Excel Programming
    Replies:
    2
    Views:
    323
    Guest
    Dec 3, 2004
Loading...