• 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...

  • 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

R

rcriceinc

New Member
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?
 
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
 
You must log in or register to reply here.
Back
Top