Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Add a button in the icon bar 2
- Thread starter XeroLui
- Start date
-
2
- #2
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.
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.
- Status
Similar threads
- Locked
- Question