Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
customize buttons
Hello,
I am trying to figure out if I can have 2 custom buttons. 1 to turn off auto calc. 1 to turn on auto calc is this possible? I guess i could write custom vba code. but I am looking in the customize. and I cannot find them, already created. thanks |
#2
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
customize buttons
As far as I know, you'll have to write a couple of VBA macros to do that and
assign them to the 2 buttons. Sub TurnOnCalculation() Application.Calculation = xlCalculationAutomatic End Sub Sub TurnOffCalculation() Application.Calculation = xlCalculationManual End Sub -- Regards, Juan Pablo González "greg" wrote in message ... Hello, I am trying to figure out if I can have 2 custom buttons. 1 to turn off auto calc. 1 to turn on auto calc is this possible? I guess i could write custom vba code. but I am looking in the customize. and I cannot find them, already created. thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Option Buttons/Radio Buttons | New Users to Excel | |||
Form buttons vs. ActiveX Buttons | Excel Discussion (Misc queries) | |||
have toggle buttons but everytime print preview buttons move | Excel Discussion (Misc queries) | |||
How can I customize the buttons in a MSGBOX? | Excel Programming | |||
Control Buttons vs. Command Buttons | Excel Programming |