Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a macro to toggle the calcuation button, but wish to convert it to an
..xla that I can share with my co-workers more easily. Does anyone know how to do this so that the macro exists along with the button? I am not experienced in this area. Also, does anyone know how to improve the macro so that I can tell by the button image if calc is on or off? Thanks much! Here is the macro below. Sub ToggleApplicationCalculation() If Application.Calculation = xlManual Then Application.Calculation = xlAutomatic MsgBox "Calculation toggled to Automatic." Else Application.Calculation = xlManual Application.CalculateBeforeSave = True MsgBox "Calculation toggled to Manual." End If End Sub 'ToggleApplicationCalculation |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Toggle Button | Excel Worksheet Functions | |||
Need to Use 1 Button to toggle On or Off | Excel Discussion (Misc queries) | |||
Toggle Button | Excel Worksheet Functions | |||
Toggle Button | Excel Programming | |||
Toggle Button | Excel Programming |