<div>
I don't believe that you can turn off autocalc on a range of cells, but you could put the formulae of those cells into a macro and then run the macro when a key combination is pressed.
</div>


I don't believe that you can turn off autocalc on a range of cells, but you could put the formulae of those cells into a macro and then run the macro when a key combination is pressed.

<div>
@MacroShadow<br />
<br />
with your code the problem is that if the cells inside A1:A10 are linked to ones outside A1:A10 then it will recalculate them as well
</div>


@MacroShadow

with your code the problem is that if the cells inside A1:A10 are linked to ones outside A1:A10 then it will recalculate them as well

<div>
Good point. Let's see what the OP has to say, for all you know they may not be linked to cells outside the range.
</div>


Good point. Let's see what the OP has to say, for all you know they may not be linked to cells outside the range.

<div>
No linkage in my example, all good! <br />
<br />
Thanks
</div>


No linkage in my example, all good!

Thanks

<div>
<div class="content wysiwyg-content">
I have a range of cells (A1:A10) in Sheet &quot;xyz&quot; <br />
<br />
They have very demanding formula which i do not want to affect the rest of my spreadsheets performance. <br />
<br />
Can (perhaps on opening the spreadsheet) the autocalc on this range be disabled and only gets enabled when a user clicks a button, so i may need a line of code to disable on opening and a line of code to put in a sub, that i can assign a button too.<br />
<br />
Many thanks
</div>
</div>


I have a range of cells (A1:A10) in Sheet "xyz" 

They have very demanding formula which i do not want to affect the rest of my spreadsheets performance. 

Can (perhaps on opening the spreadsheet) the autocalc on this range be disabled and only gets enabled when a user clicks a button, so i may need a line of code to disable on opening and a line of code to put in a sub, that i can assign a button too.

Many thanks

Set a range to not calculate and then on pressing a button, calculate

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Visual Basic Classic

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.