Add a button in the icon bar 2

[XeroLui]

How to make a button for enable/disable the "automatic calculation" in the MS-Excel icon bar?

 

[Neddy]

You need to write a small macro, place a button on the toolbar, then assign the macro to the button.

This code works in Excel 2000:


With Application
If .Calculation = xlCalculationManual Then
.Calculation = xlCalculationAutomatic
Else
.Calculation = xlCalculationManual
End If
End With



Create a macro in your worksheet called ToggleCalculate, then go into the VB editor and paste the code between the Sub ToggleCalculate() and End Sub lines.

Now go to the worksheet, right click on the toolbars, and click Customize from the drop-down menu. Select the Commands tab, select Macros, then drag-and-drop the Smiley Face icon to your toolbar (you can edit it later). Close the Customize dialog.

Finally, right-click on the new icon, and select Assign Macro. From the Macros list, select ToggleCalculate.

Should do it.