R rcriceinc New Member Jun 17, 2017 #1 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?
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?
N NARAYANK991 Excel Ninja Jun 17, 2017 #2 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
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
