1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel auto calculate on open

Discussion in 'VBA Macros' started by rcriceinc, Jun 17, 2017 at 5:42 AM.

  1. rcriceinc

    rcriceinc New Member

    Messages:
    13
    I am trying to set up a macro that will stop auto calculate on open. Maybe this is not the right approach. When the workbook opens auto calculation is taking precedence over the macro. Maybe I am making this harder than it should be. Options anyone?
  2. NARAYANK991

    NARAYANK991 Excel Ninja

    Messages:
    14,654
    Hi ,

    This is what Charles Williams of FastExcel fame has to say on this :

    If Excel is in automatic mode when the workbook is opened the calculation will take place before any VBA event fires, so you cannot prevent it.

    Narayan

Share This Page