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?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Bura Tino

    recalc question

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

    Not recalc in custom function

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

    UDF recalc question

    Steve, Mar 11, 2004, in forum: Microsoft Excel Programming
    Replies:
    3
    Views:
    286
    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:
    223
    Sandy V
    Apr 9, 2004
  5. Bura Tino

    Recalc versus enter

    Bura Tino, Apr 29, 2004, in forum: Microsoft Excel Programming
    Replies:
    20
    Views:
    419
    Bill Renaud
    May 3, 2004
Loading...

Share This Page