Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Excel 2003
I created a button using Right-click-on-control-bars Customize, and assigned the following macro to it: Sub ToggleCalculation() Dim myBar As CommandBar, myControl As CommandBarButton Set myBar = CommandBars("myMacros") Set myControl = myBar.Controls("ToggleCalculation") If Application.Calculation = xlCalculationAutomatic Then Application.Calculation = xlCalculationManual myControl.State = msoButtonUp ElseIf Application.Calculation = xlCalculationManual Then Application.Calculation = xlCalculationAutomatic myControl.State = msoButtonDown End If MsgBox myControl.State End Sub When I press the button, the calculation setting does toggle. But the button stays in the "up" position (.State = 0). Any ideas? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
replace state names with state code abbreviations | Excel Worksheet Functions | |||
How can I show state-by-state data (as silos) on a map of NA | Charts and Charting in Excel | |||
Converting State Names to State Abbreviations | Excel Discussion (Misc queries) | |||
Error Control no work :( | Excel Programming |